1. keep the database sorted on your favorite field 2. use a binary search
-bob mckenzie, palm pdx -----Original Message----- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 8:58 AM To: Palm Developer Forum Subject: Newbie search database question Hey all, I have a simple database with 2 fields, a quantity and an item number. I have about 2000 records in the database and I need to quickly lookup items by the item number on a regular basis. The item number is a 20 char string. What is the best way to go about this? Right now I just go through every record looking for a match but of course this is extremly slow. Thanks in advance! Tim A -- 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/
