Jon Blackman wrote:
I'm sure the SF filtering is optimized about as much as it can be, but it's very general and doesn't work well for thousands of records. To speed it up, you could manually go in, and get the 10-15 records you want displayed and put them into a separate display only database which is linked to the list in the form or whatever. Then if the user wants to scroll down, you empty the table and put the next 10-15 records into the display only table. Because you're only dealing w/ 10-15 records at a time, if you know the index and the table is sorted and everything, you _should_ be able to considerably speed up many of the operations.Thanks Matt. I have spent about 3-4 years on one app, and I am trying to get up to speed in CW for extensions or a complete rewrite of my SF app. A faster filter is an interesting idea. Since filtering is built into SF, I had assumed it was already coded optimally in C.
Matt
Yes, rewriting a SatForms app with 15000 records in CodeWarrior would speed it up a lot (assuming you do it right). Depending on the size of your app and how often you're using all 15000 records, you might also consider writing a SatForms Extension to do faster, more focused filtering of your data than the regular SF filters. Depending on your app, this could be less invasive and let you keep most of your existing
app.
Matt
-- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
