After some tests, with the new sqlite3.c source, seams that the behavior is better than before. So I see the -shm and -wal file grow up, and in VMMap I can see the Mapped File of -shm growing up, but not so much as before. With VMMap I can see only -shm mapped files of 32K or 64K and I'm able to reach about 5MB of mapped files with a -shm of 2MB. When the connection with the DB is closed I can see -shm -wal back inside the DB and all the mapped file disappear. The only thing I'm thinking about is the behavior that I obtain if I have 1 connection that is kept active from the beginning of the application till the end. In this situation (with the DB connection always active) I can see only Mapped File grow up, till 5MB....is there a limit that make impossible to the Mapped File to waste all the memory even if I leave the connection open? Anyway I leave my application running till tomorrow, so I can tell you more about this situation.
Il 10/09/2010 12.16, Michele Pradella ha scritto: > ok, Dan already sent me a sqlite3.c source, and I'm doing some > tests...I let you know the results > > Il 10/09/2010 12.12, Max Vlasov ha scritto: >> On Fri, Sep 10, 2010 at 12:53 PM, Dan Kennedy<danielk1...@gmail.com> wrote: >> >>> The bug is fixed by Shane's patch linked earlier in the thread. With >>> the patch, an 11MB -shm file is mapped into memory in around 350 chunks >>> with an average size of 48KB. Total address space used is around >>> (350*48KB). >>> Instead of the (350*5.5MB) that 3.7.2 was using. >>> >>> >> Dan, thanks >> I tried the patched version, It seems now the sizes changes only between 32k >> and 64k, I hope I will make additional test with large data insert today. >> >> Michele, you can download this file: >> http://www.maxerist.net/tmp/sqlite3_sqlite3_f213e133f6.zip >> I kind of injected modified os_win.c from the full package into 3_7_2 >> amalgamation. >> >> 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