Thank you all very much for your input. I guess my best bet is to reorganize the data into larger but fewer records. Thanks again
--- Mark Palatucci <[EMAIL PROTECTED]> wrote: > The data should be structured to 1) minimize the > search time 2) > minimize the hotsync time > > Depending on the comparison function, it could take > several seconds > just to check a few thousand records. A linear > search just might not > cut it. I've worked on similar large databases with > many records. In > order to get decent performance I always added an > extra record or two > with sort information. This allowed me to do > extremely quick binary > lookups. > > Also, how big (on average) is each record? Will they > always be the > same size? If so, you may want to consider packing > as many as you can > into the fewest number of records. This will > increase your sync speed. > > Also, don't forget each record adds 8 bytes of > header. My tests suggest that the OS > actually keeps a little more than this. In my > experience, even with > small record sizes, I could only get around 30k > records on an 8meg > device (event though 30k * (recordsize + 8 bytes of > headers) was > about 400-500k less than 8meg. > > -mark > > > > On Thu, Oct 03, 2002 at 12:05:06PM -0700, Lucy > wrote: > > I have an option to install the PBD as one large > db > > (23,000+ recs) or as a few smaller dbs (5000 recs > > each). My goal is to search against all those > records > > according to user's input. I will have to order > the db > > (or dbs) by first 2 fields. > > > > Which way I should go? I know the hotsync is a lot > > faster: 30 mins/db vs 10 mins/multi dbs. What > about > > performance, etc? > > > > Any input is greatly appreciated. > > > > __________________________________________________ > > Do you Yahoo!? > > New DSL Internet Access from SBC & Yahoo! > > http://sbc.yahoo.com > > > > -- > > For information on using the Palm Developer > Forums, or to unsubscribe, please see > http://www.palmos.com/dev/support/forums/ > > -- > For information on using the Palm Developer Forums, > or to unsubscribe, please see http://www.palmos.com/dev/support/forums/ __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
