I have a seach page and a result page in my app. The result page deals with a completely different db from the search page. When I come back from the result page to search again, which way is better(faster): close the db in result or leave it open? I am thinking to close the db right after I finished matching records.
My db in the result page is big, more than 22,000 records and close to 2MB in size. If I choose to close the db first, will the "sort" be performed again when the user search again? - I know sorting is very expensive so I've already sorted the db in Access. However, even though the records are already sorted, I still have to call sort in my code in order to generate the index, right? Any thoughts? ===== __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
