I have had the same experience. I have used the Palm install to install PDB
files of approx same size but with different no. of records. I had created
the PDB files in the PC,keeping the same size of data in the records. The
diff. in the file size is due to the no. of records in the database header.
Record nos. File name File size Time taken(58 Kbps)in Sec.
10 Recfew.pdb 587KB 120.629
1000 Recmore.pdb 595KB 156.967
10,000 Reclots.pdb 674KB 1140.530
This was a rough test, and timing wasn't very accurate. But, you can see
that the file with 10 records installs approx. 10 times faster than the file
with 10,000 records.
-Sugho-
>From: "Gordon, Douglas" <[EMAIL PROTECTED]>
>Reply-To: "Palm Developer Forum" <[EMAIL PROTECTED]>
>To: "Palm Developer Forum" <[EMAIL PROTECTED]>
>Subject: Re: Large database synchronization
>Date: Wed, 9 Feb 2000 07:55:07 -0500
>
> > Has anyone any experience with synching large numbers of records and/or
> > methods of optimizing the synch? We are synching upwards of 32,000
>records
> > of about 40 bytes each (painful overhead cost per record, I know) and =
>it's
> > taking about 2 hours (synch rate: ~2.3K BPS - whats up with that?!?)
>
>My experience is that synch time is highly dependent on the number of
>records as opposed to the size of the records. I used to have a database
>with several thousand very short records that took forever to transfer on a
>synch. I changed my design to combine the data into just a few records of
>several thousand bytes each, with my program internally handling the
>details
>of the "logical records" that are inside the database records. It was just
>a
>bit more coding to handle this, but it now synchs more than 10 times
>faster!
>
> Doug Gordon
>
>
>--
>For information on using the Palm Developer Forums, or to unsubscribe,
>please see http://www.palm.com/devzone/mailinglists.html
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palm.com/devzone/mailinglists.html
