Do you have your inserts wrapped in a single transaction? It used to be that I wasn't worrying about transactions in my projects, but I noticed things were very slow. I realized that it was creating and committing one transaction for each insert I was doing. When I wrapped all inserts into a single transaction, speed jumped dramatically.
But, of course, this doesn't address your memory issue. Unless the increased memory is somewhere in the transaction management logic. RobR -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of rui Sent: Thursday, November 15, 2012 12:21 PM To: [email protected] Subject: [sqlite] memory leak in transactions 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
