>If you have two copies of a database and you want to compare the records, >and perhaps combine numerical fields for each record, is there a faster way >to compare them than reading records one by one in the first database and >then comparing them to the entire second to find a match?
Presort both databases on an indentical sort key if there is one, then you should be able to read through each file only once. You can find details on appropriate algorithms in a book like Knuth's Sorting and Searching. Regards, Steve Mann -- Creative Digital Publishing Inc. 1315 Palm Street, San Luis Obispo, CA 93401-3117 ------------------------------------------- 805.784.9461 805.784.9462 (fax) [EMAIL PROTECTED] http://www.cdpubs.com -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/tech/support/forums/
