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
