Hello guys, I need your help in order to solve a very annoying issue with sqlite 3.6.11.
I have two opened db inside my application and when I insert 180,000 rows inside a transaction I can see heap memory usage that exceeds 100MB (data is written twice so I have 2 transactions inside two different db each one that write 180,000 rows). I tried to use the sqlite3_soft_heap_limit without much luck(with SQLITE_ENABLE_MEMORY_MANAGEMENT defined) ... please note that transactions are started with BEGIN EXCLUSIVE. I think that the new sqlite versions simply try to cache as much data as possible (memory usage was much lower with version 3.2.1 for example) ... so, how can keep memory usage low or to a limit similar to the old versions? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
