Hi Max, I got the problem in both situations: 1. I have a journal_mode=DELETE database and I convert it to WAL. 2. I create a new database with WAL mode.
I never check the handles in the task manager, but I always see the mapped files in vmmap growing up. I think it's the same. Anyway I have the memory wasted especially when I have a quite big DB(about 1.2GB with about 17milions of records) and I try to Delete a lot of records: in this situation I see mapped files growing up and waste a lot of memory (I reached the maximum 32bit windows memory limit so my application crash). ps.With this DB the "SELECT count(ID) FROM table_name" it's very slow...it take minutes(with the sqlite shell)! Il 09/09/2010 17.04, Max Vlasov ha scritto: > 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 > > -- Selea s.r.l. Michele Pradella R&D SELEA s.r.l. Via Aldo Moro 69 Italy - 46019 Cicognara (MN) Tel +39 0375 889091 Fax +39 0375 889080 *michele.prade...@selea.com* <mailto:michele.prade...@selea.com> *http://www.selea.com* _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
