I've just discovered (perhaps everyone else already knew)
that tcl arrays used to hold query results are not cleared
before they're used. If the same array is used repeatedly,
it can get quite large and affect execution time. More
details are at <http://www.sqlite.org/cvstrac/tktview?tn=547>.
The work-around is simple; just clear the array after each
use:
dbcmd eval {select a, b, c from ...} h {tcl-code}
array unset h
dbcmd eval {select x, y, z from ...} h {tcl-code}
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
