Jay Sprenkle wrote:
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
Hi,
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.
Certainly!
http://sqlite.org/capi3ref.html#sqlite3_prepare
I believe that Dr Hipp has available a special version of Sqlite which
stores prepared statements. It has restrictions which may make it
unsuitable for general purpose applications, but could be the answer
this user is looking for.
For the benefit of the user, sqlite3_prepare compiles an Sqlite
statement but the compilation is only valid for the life of the
process and while the schema is not altered. It also requires that
the raw SQL be in memory at some stage.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
