> 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.
>
Hi.
I have the same problem.
I tried to use DmFindSortPosition.Because it does a binary search,and when DB is
sorted you can quickly find position for inserting record.
It works very fast,but it returns index of next record (after those ones which
matches).
It should be something like DmFindSortPosition (doing binary search, but returning
first one matches).
I went thru Reference but didn't find it.
There is one condition: DB must be sorted.
I tried to find out how to remember several sort orders.
They told me that PalmOS doesn't have support for that.
I did my own indices (remembering uids of records) but it works good only for
displaying not for searching.
So there is a real problem.I started to worry if there is a solution for that.
If you find a way for solving that PLEASE let me know.
Thanks in advance.
Wojtek
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
