Hi, >Anyone have ideas on what we be the most effecient way to find a >record when working with an extremley large number ( 9000+ ) i need >to find a record by a field in that record, and i do not know the >index.. currently i'm doing dmqueryrecord then finding the next one >and comparing the field.. but this is very ineffecient. all >thoughts are welcome. you could build some B-Tree (that seem quite well to be stored directly into an index database) : one node per record by example. if your large database is produced on a desktop and only read on handheld you may also use some special records at the begin of your database, simply with indices sorted in the right order wrt the given index criterium. Regards, Armel Asselin www.mobipocket.com -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/tech/support/forums/
