Eric, Sort de Database and use Binary Serach.
If you have a databse with 1024 records, you will find your specific record
at a max of 10 reads.
At 10:44 AM 5/10/00 -0400, you wrote:
>Hello everyone. This is not a problem but more of a size question.
>
>I have three databases, first one has about 500 records and the second has
>about 800-1000 records. Each record is about 2-3K in size.
>
>My question is, are these database sizes normal (i.e. are other people
>programming with such large databases?). I ask this because I am having
>some trouble with going through each record for the first 500 records and
>then taking the foreign key to match a record in the second database. This
>is taking about 15-20 minutes to go through it all. Is it because of the
>database sizes or because of my limited knowledge with database and the
>searching capability that Palm comes with?
>
>Thanks,
>Eric Sun
>Developer - RAD systems
>Q. Data Inc.
>5/10/00 10:24 AM
>
>--
>For information on using the Palm Developer Forums, or to unsubscribe,
>please see http://www.palmos.com/dev/tech/support/forums/
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
