Ok I think that the latest patch I used to try the WAL is the patch that fix the problem. I do not get wasted memory by mapped file ;) good job. Anyway I leave the application running this day. If I have news I'll tell you. Just a question: when you plan to release a new version of sqlite with this patches?
Il 10/09/2010 20.46, Max Vlasov ha scritto: > On Fri, Sep 10, 2010 at 6:32 PM, Shane Harrelson<sh...@sqlite.org> wrote: > >> I tried to reproduce this, and could not. >> >> There are some questions inline below. Additionally, I want to >> verify that you've tried this with a version of SQLite containing the >> previously linked fix. >> >> > Shane, the fix helped, the thread is a bit mixed, the information I posted > (and you had questions about) was about non fixed 3_7_2, now I finally did > the test with the patched library.2,000,000 appends were made without any > problem. > > > On Fri, Sep 10, 2010 at 5:37 PM, Michele Pradella< > michele.prade...@selea.com> wrote: > >> ...connection do the operation that in my situation cause the -shm Mapped >> File grow up, Am I sure that sqlite do not waste application's memory >> even if I never close the DB connection? is just a question, and anyway >> I got my application running to test this behavior. >> >> > Michele, I think, giving this calculation, you can be sure of about 2G*128/2 > (~128G) size of the db till the mapped address space is out. But are you > sure you want appending without committing for months? I doubt you consider > the saved information valuable in this case since a chance of a power or > system failure is higher and higher each day :) > > 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