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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
