Re: [sqlite] SQLite Memory Pool overflow probelm

Thanks Simon for response. I got the problem. I need to use the the macro * SQLITE_DEFAULT_CACHE_SIZE= *The documentation can be found at *http://www.sqlite.org/compile.html * The default configuration is 2000 pages which is not fitting into 256 KB of memory pool. I have reduced

Re: [sqlite] SQLite Memory Pool overflow probelm

On 6 Aug 2009, at 9:43am, shankar m wrote: > I am able to reproduce the problem in normal PC also. > > I am using sqlite3_exec statement > * > rc = sqlite3_exec(db, "INSERT INTO city (name, state) VALUES('ggg', > 'abcdef')", callback, 0, &zErrMsg);* > > After your suggestion i used transcation st

Re: [sqlite] SQLite Memory Pool overflow probelm

I am able to reproduce the problem in normal PC also. I am using sqlite3_exec statement * rc = sqlite3_exec(db, "INSERT INTO city (name, state) VALUES('ggg', 'abcdef')", callback, 0, &zErrMsg);* After your suggestion i used transcation statements. For every 1000 insertions i am doing a commit. Bu

Re: [sqlite] SQLite Memory Pool overflow probelm

On 5 Aug 2009, at 10:27am, shankar m wrote: > 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 spac

[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