chetana bhargav wrote: > Is there any way to pre compile some of the prepared statements during > compile time. I am having 4 tables of which two tables doesn't create any > triggers/joins. I am basically trying to speed up the queries on these tables > (as they are most frequently used). I am looking for ways so that I can keep > them prepared always, not in memory though as that would be too much.
Statements are always prepared! They only get 'unprepared' or discarded if you call sqlite3_finalize(). You can use a prepared statement over and over again by calling sqlite3_reset() between uses. Roger ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------