Does anyone know of a fast way to search through a very large database (17000 records)?
I currently use the the standard approach:
for (UInt16 recordNum = 0; recordNum < DmNumRecords(db); recordNum++)
{
MemHandle dbRecordHandle = DmQueryRecord(db, recordNum);
MemPtr dbRecordPtr = MemHandleLock(dbRecordHandle);
... check if data matches search criterion
MemHandleUnlock(dbRecordHandle);
}
This takes about 20 seconds.
I have successfully used DmFindSortPosition when looking for data that is sorted, but I
cannot think of any way to speed up the search for other data.
Any ideas?
Laurie
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/support/forums/
