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 Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/tech/support/forums/
