A linear scan of a 300 records probably won't take long enough to be noticed
by the user, but if you want to do something for each record that requires
this linear scan, you end up with an n squared problem, and that will be too
slow. So, for example, if you have records in one database that contain the
unique ID of records in other databases, and you want to scan each of the
records in the first database and look up the corresponding records in the
other databases, then you're likely going to have a performance problem. You
may be able to improve performance by sorting databases by the unique IDs of
their records and using a binary search to locate records rather than
DmFindRecordByID.
--
Peter Epstein
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
