Hi, I am seeing explosive memory growth when i am using transactions using System.Data.SQLite.
I see this when the transactions which were before taking fraction of second, taking 15 sec for 50 row insert into a table. I have tried to use sqlite3_db_release_memory but that only frees upto 2mb after every transaction. After some time say half an hour - i do see memory usage drop but that's not acceptable. All the object are properly disposed from trasnsaction to command etc. The SQLiteConnection is kept open for the life time of the session, which could span hours. I would really appreciate if somebody can help me in getting the reason for such excessive memory usage, i have seen working set(memory)go up from 70 mb to 400 mb in 1 minute where three transactions only doing 50 insert in a table. Regards, Raj _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
