ok, I think I'll use the snapshot in the mean time. Thank you
Il 16/09/2010 15.43, Richard Hipp ha scritto:
> 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
>>
>
>
--
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
