On Thu, 21 Nov 2002 15:33:26 -0600 Ben Combee <[EMAIL PROTECTED]> wrote:
> > > You can use a single PDB, but it would be a very good idea to combine > > > multiple records into a single Palm OS record. If you don't, then your > > > HotSync times will be outrageous. > > > >That's true. i think i'll keep track on the modified records on the host > >machine > >and only transfer those who had been modified since the last sync. > > That doesn't help the initial HotSync... Just copying a DB with 30000 > records to the device is an ordeal, as the device has to do 30,000 separate > memory allocations, plus 30,000 record index reallocations. It can get > really, really painful. Ben, as usual, you're right. i've created a test database and currently uploading it on the Palm. The sync started at 22:11:48, 40 minutes ago ;) I've tried with 1000, 2000 and 5000 records. While 1000 is an acceptable figure, 2000 is quite slow and 5000 is unacceptable. > > >Luckly the Palm doesn't need to alter them. > > > >30000 records is quite near to 2^15 or Int16, which is the limit > >on the lists, AFAIK. How am i supposed to break the barrier? > > By combining multiple records into one and doing your own > indexing. Remember that the Palm OS DB format was designed for things like > to-do lists and address books that have a few hundred records at most. I think i'll try a 50:1 or a 100:1 split factor. Is there any example available? My records can have a variable length: maybe that's the right time to fix them or i'll have to put a jump table on each "big" record. -- Alessandro Zummo, Tower Technologies - Turin, Italy -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
