"Ben Combee" <> wrote in message news:[EMAIL PROTECTED] >> 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? > > I don't know specifically about this, but I doubt there will be NVFS > changes in the near future or in patches released for existing devices > that would affect this behavior. I think this came on in 5.4.9 which > moved to a newer NVFS implementation that's more stable and does > MemHandle-based locking instead of DmRecord-based locking. It looks > like QuickSort is hitting some bad DBCache behavior since it tends to > open records in a much-less ordered way. >
Thank you for your reply, Ben. I guess the best solution right now will be to simply duplicate those multi-megabyte databases with different sort orders, so that QuickSort does not have to be called on the handheld. The added storage requirements of that solution are definitely easier to swallow than the painful sort performance. If you have a chance to point the right people at Access towards this issue, that would be much appreciated. 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/
