Thanks Simon for response.
I got the problem. I need to use the the macro *
SQLITE_DEFAULT_CACHE_SIZE=<pages>
*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 it and now its working fine :-)
Regards
Shankar
On Thu, Aug 6, 2009 at 4:06 PM, Simon Slavin <[email protected]>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 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.
>
> The documentation for that command
>
> <http://www.sqlite.org/c3ref/exec.html>
>
> says
>
> "The calling function should use sqlite3_free() to free the memory
> that *errmsg is left pointing at once the error message is no longer
> needed."
>
> I don't know enough about the way the library works to understand
> whether you need to do this after each call to sqlite3_exec.
>
> 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
