If the total size of the database is less than, say, 70% of the total dbcache
available on your device (you might check that), you could try to move the
whole database into RAM, e.g., by locking every record. I don't know if it'll
let you sort it then, but it might. You'll probably end up forcing a dbcache
flush by locking it, and that'll take about 20-40 seconds, but after that
things will be fast. Then you release the records, dmdatabasesync, and you
should be done. But test it carefully first. I have a feeling (more than a
feeling, actually; some Treo 650 crash report for early versions of OffFlush
support this hunch) that NVFS may not be that reliable with large databases on
some devices.
--
For information on using the ACCESS Developer Forums, or to unsubscribe, please
see http://www.access-company.com/developers/forums/
