Greetings, In our tests across various PalmOS devices, we are seeing significant performance problems using DMQuickSort on large databases on devices using the latest NFVS implementation.
Specifically, we are seeing very slow performance quicksorting 18000-record databases on these devices with the newest NVFS version: - Palm TX (avg quicksort time ~100 seconds) - Palm Treo 680 (avg quicksort time ~120 seconds) - Janam XP30 (avg quicksort time ~60 seconds) Quicksorting those same databases on the following devices with an older implementation of NVFS results in much quicker performance: - Palm TE2 (avg quicksort time ~20 seconds) - Palm Treo 650 (avg quicksort time ~15 seconds) - Palm TT5 (avg quicksort time ~10 seconds) - Palm LifeDrive (avg quicksort time ~10 seconds) !! surprising Just for comparison's sake, this was also tested on some older non-NFVS OS5 devices: - Palm TT (avg quicksort time ~55 seconds) - Garmin 3600 (avg quicksort time ~14 seconds) - Palm Zire72 (avg quicksort time ~11 seconds) Also surprisingly, on the newer NVFS devices tested the time to complete an insertion sort on the same unsorted 18000-record database was less than the time to use quicksort. This is contrary to expectations, and contrary to the experience on older NVFS and non-NVFS devices, where the quicksort was always faster than insertionsort. Can anyone from Access/PalmSource and/or Palm Inc. comment on these NVFS quicksort performance results? Is this problem going to be fixed in the next NVFS revision, are there suggestions to improve sorting performance other than "use less records", etc.? Ben Combee? Greg Wilson? Regards, David Thacker http://www.SatelliteForms.net The Premier RAD Tool for PalmOS & PocketPC -- For information on using the ACCESS Developer Forums, or to unsubscribe, please see http://www.access-company.com/developers/forums/
