On 3/29/17, Hick Gunter <[email protected]> wrote: > The Close (1) in the second program is closing (=deleting) the ephemeral > table. I have no idea if this would also be handled in Halt or not.
OP_Halt always closes all open cursors. Calling sqlite3_reset() does too. In fact, it's the same block of code that does both. One could omit all OP_Close opcodes and I think everything would still work. But sometimes an OP_Close can free up resources sooner rather than later. Also, some b-tree operations are faster if there is only a single open cursor on that b-tree, and so it is advantageous to keep the number of open cursors to a minimum. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
