Does anybody knows the exact code, a little hack where can I free up the
memory, I don't want it to use it for future requests.
Even drop table consumes memory. :-(.
If we are doing in-memory database operation, why do we want to maintain the
free'd memory pages?
I think If Mr. Hipp answers, it will be better... :-)
On 8/3/07, Christian Smith <[EMAIL PROTECTED]> wrote:
>
> Scott Derrick uttered:
>
> > are you saying this is a memory leak?
> > sqlite never gives back the unused memory?
>
>
> No, libc never gives back the memory.
>
> It is not leaked because the malloc implementation keeps a reference to
> all the free'd heap memory in tracking it for future requests.
>
>
> >
> > Christian Smith wrote:
> >> Lokesh Babu uttered:
> >>
> >>> Hello Folks,
> >>>
> >>> When I perform the DELETE operation on a Table using In-Memory
> Database
> >>> (":memory:"), the memory usage increases.
> >>>
> >>> I tried using PRAGMA auto_vacuum=1; /* result - nothing works */
> >>> Even I tried using VACUUM table_name; /* this too isn't work */
> >>>
> >>> if I perform DROP the table operation, memory usage works. Deleting
> the
> >>> rows
> >>> doesn't work.
> >>>
> >>> Anybody please help me in resolving this.
> >>
> >>
> >> Memory usage goes up because SQLite must temporarily store copies of
> the
> >> old pages that store the deleted rows, in order to allow a future
> rollback
> >> if required.
> >>
> >> Once a commit is done, the old pages are free'd, but by that time the
> >> memory footprint has already increased. Not many libc implementations
> >> release heap memory back to the OS once it's allocated.
> >>
> >>
> >>>
> >>> Thanks in advance,
> >>>
> >>> Lokee
> >>>
> >>
> >> --
> >> /"\
> >> \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
> >> X - AGAINST MS ATTACHMENTS
> >> / \
> >>
> >>
> >>
> -----------------------------------------------------------------------------
> >> To unsubscribe, send email to [EMAIL PROTECTED]
> >>
> >>
> -----------------------------------------------------------------------------
> >>
> >>
> >>
> >>
> >
> >
>
> --
> /"\
> \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
> X - AGAINST MS ATTACHMENTS
> / \
>
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -----------------------------------------------------------------------------
>
>
