Thanks Dave for your input. Actually, the total number of records are exactly the same in both situations. What I am thinking of doing is that I would break the big db into 4 smaller ones by product-id in Access first. Of cause, I would have to modify my code a bit in these two different situations. I am not doing much in my code, so the change is really easy to make.
What I concerned the most is the performance issue: One DB: there is only one sort but the search operation has to go through more records. multi DBs: 4 sorts with less records each. Since I know the product-id from user input, I can go directly to one of the 4 dbs. That means less records to go through each search. But which is better? I tried both on my Palm, the answer is not very obvious or convincing. I was wondering if anyone knows the better way theoretically. Thanks. --- Dave Lippincott <[EMAIL PROTECTED]> wrote: > Whichever layout that produces the fewest total > number of records. The more > records, the slower the sync. > > ----- Original Message ----- > From: "Lucy" <[EMAIL PROTECTED]> > To: "Palm Developer Forum" > <[EMAIL PROTECTED]> > Sent: Thursday, October 03, 2002 3:05 PM > Subject: large DB vs multi small DBs on Palm > > > > 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!? 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/
