Re: [sqlite] Precompiled statements in the TCL interface

2004-12-31 Thread Roger Binns
The TCL interface to SQLite does not currently support precompiled statements. Each SQL statement executed is compiled for that one execution. If the same statement is executed multiple times, it is compiled multiple times. This note considers ways of addressing that deficiency. Incidentally my

Re: [sqlite] Precompiled statements in the TCL interface

2004-12-31 Thread Mrs. Brisby
On Fri, 2004-12-31 at 08:30 -0500, D. Richard Hipp wrote: > The issue with the third approach is deciding when to clear the > precompiled statement cache. Precompiled statements use memory > and we do not want them to hang around forever. Why not? Programs that "generate" SQL are often-foolish. P

[sqlite] Precompiled statements in the TCL interface

2004-12-31 Thread D. Richard Hipp
The TCL interface to SQLite does not currently support precompiled statements. Each SQL statement executed is compiled for that one execution. If the same statement is executed multiple times, it is compiled multiple times. This note considers ways of addressing that deficiency. The most obvious