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 ACCESS Developer Forums, or to unsubscribe, please see http://www.access-company.com/developers/forums/
