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. 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 <[email protected]>wrote:
>
> 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 space. I cannot insert anymore.
> >
> > How to free the memory pool for further insertion? Do I need to do any
> > further configuration?.
>
> Are you using transactions around your 5000 inserts ? Do you use
> BEGIN at all ? If so, do you use COMMIT after each INSERT or each
> 1000 INSERTs ? Or are you still inside the same transaction when you
> hit your 5000th INSERT ?
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
