[EMAIL PROTECTED] wrote:
> The TCL bindings also keep a cache of recently used SQL
> statements. The bindings automatically detect if the SQL matches a
statement in cache
> and reuse the existing sqlite3_stmt if it does.
Does the TCL wrapper allow multiple commands in one go? eg can it be
called with {select 3 ; select 4} ? Assuming so, it would require the
statement comparison to be identical, even including whitespace.
Also, how do you deal with threads correctly if the same database handle
is used across threads?
> Other language
> bindings and wrappers would do well to emulate this design.
Several years ago you did post an email implying you'd could do the
statement caching as part of SQLite itself rather than having all the
wrapper authors re-invent the wheel. I can't find that email any more ...
Roger
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
