If you want to improve hotsync time, reduct the number of records by collation many access records into one palm record. Make the Palm records as big as they can be (64K max). This will make hotsyncing MUCH MUCH faster. YMMV.
Alan "Lucy" <[EMAIL PROTECTED]> wrote in message news:97290@palm-dev-forum... > > 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/
