>... It's the record count, not the size that's the problem. Currently
>we're evaluating PDBcruncher ... this works well (5mins instead of 30+). The
>only problem is that you need room on the device for both the current
>database and the packed one. It's also an additional step for the user to
>install the utility.
>
>Another alternative is to pack the records into 64KB chunks and write your
>own indexing logic, which isn't ideal.
>
>I really wish Palm would address this ...
In 3.5 the performance of this improved quite a bit, if I recall correctly,
due to optimizations in the Data Manager. Doing fewer, larger records will
still help, due to the per-record HotSync time overhead. I don't recall if
there are further improvements in 4.0 or not.
And for that matter, just about everything should work faster with fewer,
larger objects. They're all indexed, after all, and invidually resizable
and moveable etc., which results in overhead. Packing stuff together
usually is helpful for transportation, which is why suitcases were invented
:-) But you don't keep your clothes in a suitcase at home; you invest in a
set of drawers since they have better access time which outweighs their
larger size!
-David Fedor
Palm Developer Support
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
