On Thu, Sep 16, 2010 at 9:02 AM, Michele Pradella < michele.prade...@selea.com> wrote:
> After some days of test the application work fine and with VMMap I see > small value of mapped file and I see only 1 instance of -shm allocated, > some times 2 but it's all ok. So I'll wait for the next amalgamation > release to have an official sources for that fix. > When do you think will be released? > The next scheduled official release is for the middle of October. But you can download a development snapshot from http://www.sqlite.org/draft/download.html and use it in the mean time. The snapshot has not been tested to the same extent that an official release has, but it is still stable and should not give you any problems. (On the other hand, if you do encounter problems with a snapshot, please let us know.) > > Il 13/09/2010 8.18, Michele Pradella ha scritto: > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
