From: "Lucy" <[EMAIL PROTECTED]> > > 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.
If the change is easy to make then it's easy to test to see which way is better (as you in fact did). > 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. When you talk about searching, are you talking about doing table scans, or using Palm OS's indexing capabilities? If the latter, then be aware that four times the number of records will not mean four times the lookup time. > But which is better? I tried both on my Palm, the > answer is not very obvious or convincing. Do you mean that both ways were about the same speed? Because that would have been my guess. In which case, do it the simplest way and move on. -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
