Re: [sqlite] Sqlite uses a lot of memory during a delete operation

Maybe LIMIT clause can be used. Please check the below link. http://www.sqlite.org/lang_delete.html Regards Shankar On Wed, Sep 9, 2009 at 5:16 PM, P Kishor wrote: > On Tue, Sep 8, 2009 at 10:48 PM, Benjamin Rutt wrote: > > On Mon, Sep 7, 2009 at 12:28

Re: [sqlite] Regarding Memory Database

d memsys5 memory pool and now are complaining > that this memory is not returned to OS? > > Sorry, but it's not quite understandable what do you want to achieve, > what's the problem with it and how did you find that there's a > problem. > > Pavel > > On Thu, Aug 27, 20

Re: [sqlite] Regarding Memory Database

're wrong in this vision. SQLite doesn't keep > memory in pools if it doesn't belong to cache necessary to some open > connection. At least SQLite calls free() which of course doesn't > necessarily mean that memory will be returned to OS. > > > Pavel > > On Wed, Au

Re: [sqlite] Regarding Memory Database

close it. And you can clearly see it in > sources... > > > Pavel > > On Wed, Aug 26, 2009 at 12:57 AM, shankar m<shankar.mah...@gmail.com> > wrote: > > Hi, > > > > I am using SQLite in a embedded system which has the following databases > >1. 64MB Flash st

[sqlite] Regarding Memory Database

Hi, I am using SQLite in a embedded system which has the following databases 1. 64MB Flash stored Database for persistent storage 2. 2 MB In-Memory Database. When the Memory Database is closed the 2MB should be returned to the operating system. The 2 MB will be reallocated when the

Re: [sqlite] SQLite Memory Pool overflow probelm

reduced it and now its working fine :-) Regards Shankar On Thu, Aug 6, 2009 at 4:06 PM, Simon Slavin <slav...@hearsay.demon.co.uk>wrote: > > On 6 Aug 2009, at 9:43am, shankar m wrote: > > > I am able to reproduce the problem in normal PC also. > > > > I am using sq

Re: [sqlite] SQLite Memory Pool overflow probelm

g a commit. But then also there is no change. After 3500 insertions the SQLite memory pool overflows. Thanks in advance Regards Shankar On Wed, Aug 5, 2009 at 6:49 PM, Simon Slavin <slav...@hearsay.demon.co.uk>wrote: > > On 5 Aug 2009, at 10:27am, shankar m wrote: > > > I am runn

[sqlite] SQLite Memory Pool overflow probelm

Hi, I am running SQLite on a embedded device. For SQLite memory pool I am using memsys5 memory allocator with size of 256 KB. When i execute "insert into" command for around 5*1000 times the memory pool is full but my database file has space. I cannot insert anymore. How to free the memory pool