Hi Jason, Does it mean that it is not feasible to maintain very large number of records (palm database records) in palm? Can Oracle Lite solve this problem?
Thanks, Sam Jason Garrett <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Hi Sam, > > I would suspect that your memory could well be the problem here. > Over time your memory may become heavily fragmented, and this will cause > the progressive slow down. > > I've successfully moved large quantities of data around on the SPT1740 > across RF (TCP) > and unpacked those packets into records very rapidly. But I designed the > database such that I actually held > 128 data records in each Palm record each preceded by a data index. This > allowed me to perform faster searches, > and increase the permissible record count. > > > -----Original Message----- > > From: Sam [SMTP:[EMAIL PROTECTED] > > Sent: Tuesday, 25 July 2000 16:13 > > To: Palm Developer Forum > > Subject: Insert records to large database (> 10000 records) > > > > Hi all, > > > > i wrote a palm program to get database records from PC to palm using FTP > > protocol. the program is running on SPT1500. it works fine at the > > beginning, but when the palm database grows large, the record insertion is > > very slow. and the program throw a fatal error at last (it maybe my > > program > > bug, but it dose not due to insufficient memory). All records are > > inserted > > at the last index. > > > > Here is the result: > > In the first trial, it inserted 8072 records (each records 46 bytes) and > > then threw fatal error. it takes about 15 mins. > > In the second trial, it inserted 4141 records and then threw fatal error. > > it > > takes about 15 mins. > > In the third trial, it inserted 3307 records and then threw fatal error. > > it > > takes about 15 mins. > > > > anyone have experience on managing large database (more than 10000 > > records) > > in palm? > > > > regards, > > Sam > > > > > > > > > > > > > > > > > > > > -- > > For information on using the Palm Developer Forums, or to unsubscribe, > > please see http://www.palmos.com/dev/tech/support/forums/ > > > > -- For information on using the ACCESS Developer Forums, or to unsubscribe, please see http://www.access-company.com/developers/forums/
