My first thought is that you may not be releasing resources.
My second thought is to revisit your SQL with an eye toward optimizing it as
much as possible. For instance, are you pulling back more fields than you
really need? Are you using indexes whenever you can?
--
John T
____________________
"Vijaybabu" <[EMAIL PROTECTED]> wrote in message
news:55093@palm-dev-forum...
In short, based on search criteria from the user the application will be
querying ultarlite tables which hold the data on the device. My problem is,
the processing speed of my application get relatively slowdown on running
the query more number of times (say 8-10times).
BTW Once I exit from the application and enter, the speed will be normal and
get slower again after few transactions.
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
