On Thu, Sep 9, 2010 at 11:37 AM, Dan Kennedy <danielk1...@gmail.com> wrote:
> > On Sep 9, 2010, at 1:12 PM, Michele Pradella wrote: > > > Hi, do you have some news about the wasted memory? have you found the > > reason for the windows backend? > > Fixed here: > > http://www.sqlite.org/src/ci/f213e133f6 > > Dan, don't know whether it is related, but I detected memory leak in 3.7.2 related to handle count increasing. Steps to reproduce (Windows XP SP3, sqlite3.7.2.dll compiled with bcc) 1. Create or use previous db with the table CREATE TABLE [TestTable] ( [Id] INTEGER PRIMARY KEY AUTOINCREMENT, [Text] VARCHAR(200) ) 2. Open the db that currently in journal_mode=delete 3. Change journal_mode=WAL; 4. BEGIN TRANSACTION 4. Make 50,000 repeated queries INSERT INTO TestTable (Text) VALUES ("12345678912345.... (in my case the lengh of this string was about 1100 bytes) 5. See while the queries are processing how handles in Task manager increasing (total about 14). The followiing commit does not help in decreasing the number to the start value. I tried to look with Process explorer, it seems there are many handles titled "section". Also I could not reproduce this when the db is already in WAL mode when opened. Michele, can you tell us what is the mode when you initially open db? Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
