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
