On 28 Dec 2012, at 10:16pm, Krzysztof <dib...@wp.pl> wrote: > I thought about reopen connection (this would solve my problem in simple > way) but my dependencies are tricky. I'm using free pascal which have > TSQLite3Connection. This class handle sqlite connection, so I can attach > multiple tables in the same session, so I can share temp tables between all > tables in my database.
Okay. Well as you can guess, the memory is reused immediately you start inserting new rows. It's always available to SQLite, it's just SQLite isn't releasing it to other parts of your application. > If I close connection, I lose data from all temp > tables :/ True. If you need to do operations on multiple tables at once, there's a good reason to keep all the tables accessible using the same connection. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
