Also, what a huge amount of wasted overhead, I believe around 18 bytes per record. (18 * 30000 = 540,000). Try using DmDatabaseSize and see the difference between the totalBytes and the dataBytes. I would suggest combining 200 words per record, and storing the offset. Also, with Databases that size, it would be more appropriate to use compression, try using the ZLib library to compress each record (of 200 combined).
LionScribe "Ben Combee" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > At 01:46 PM 6/15/2004, you wrote: > >Greetings, > > > >I just posted a notice about my latin dictionary program... I have another > >question related to synchronizing the database files that go with my > >program. I use a method of creating a single record in my database for > >each word which is to be stored (and there are approximately 25000 words), > >as well as an index into this database (which has about 30,000 > >entries). The index.pdb file is only about 640K, yet takes nearly three > >hours to synchronize! The other file (the Stems.pdb file) takes about the > >same time, and is 2.5M. > > > >The only thing I can think of in this context is that the creation of so > >many individual records on the handheld side is holding up the > >synchronization... I am using a USB connection, so speed should not be a > >problem. Has anyone else had this problem, and if so, what's a good solution? > > You're right. The speed of a sync is greatly affected by the number of > records in a DB, especially on older OS versions, like OS 3.1 on your Visor. > > It would be much better for you to use large DB records that represent > multiple words. You would get much faster syncing, better memory > management, and you wouldn't hit the total-number-of-records barrier as > quickly. > > See also the palm-dev-fourm archives, where this topic was discussed to > death back in 2000 and 2001. > > > -- Ben Combee, DTS technical lead, PalmSource, Inc. > Read "Combee on Palm OS" at http://palmos.combee.net/ > > > -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
