The question is about the possibility, but I should be sure that this do not happen in my application, because I have to make my application running for month without restart. So because in first few test I always see the -shm Mapped File grow up (even that less than before the patch) and I see the memory cleaned up only after the DB connection close, my question is: if I have a DB connection active for 1 month and this 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.
Il 10/09/2010 15.20, Max Vlasov ha scritto: > On Fri, Sep 10, 2010 at 5:07 PM, Michele Pradella< > michele.prade...@selea.com> wrote: > >> what I worry about is that the Addressed space of >> sqlite (during an operation of DELETE or UPDATE a lot of data in WAL >> mode use case described before) could grow up till 2GB. This cause the >> application crash because it can allocate no more monitor. >> > > Are you talking about real tests or just a possibility? From what I see the > actual size of wal file has nothing to do with the memory available, it's > just structurally the same database pages saved separately from the main db > file and shm file is the way to find those pages for readers and for pager > to commit them. The shm file could be hungry for memory, but it's not a big > deal since it's always wants 128 times less then the size of the data > changed. > > 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
