Subject | Prepare Queries.. |
---|---|
Author | vdsgch |
Post date | 2007-11-18T05:39:59Z |
Hi,
Im wanting to speed up my app..
Ive built a Query, and I want to call it over and over in a loop..
In the loop , i set the parameters, and open it..
can I assume that I can prepare it once , when my app starts?
Then , just open it and close it in the loop?
Or, does it have to be re-prepared ever while the app is running?
My sql code wont be changing..
Im wanting to speed up my app..
Ive built a Query, and I want to call it over and over in a loop..
In the loop , i set the parameters, and open it..
can I assume that I can prepare it once , when my app starts?
Then , just open it and close it in the loop?
Or, does it have to be re-prepared ever while the app is running?
My sql code wont be changing..