Some mistakes... * I use also PRAGMA cache_size=100 but the some problem On Wed, Jul 13, 2011 at 3:12 PM, Anze Rozman <anze.roz...@gmail.com> wrote:
> Hi! > > I have an application which inserts into database most of the time. Problem > is that memory is decreasing. Aplication is in java and I use Werner's > sqlite wrapper - http://www.ch-werner.de/javasqlite/ (because of J2ME). I > use method > (*exec<http://www.ch-werner.de/javasqlite/SQLite/Database.html#exec%28java.lang.String,%20SQLite.Callback%29> > *(String <http://java.sun.com/javase/6/docs/api/java/lang/String.html> sql, > Callback <http://www.ch-werner.de/javasqlite/SQLite/Callback.html> cb) ) > from werner's wrapper. I use also page_cache=100, and I use transactions > with BEGIN and COMMIT, but the problem remains. After few hours application > eat almost all free memory. I find out that problem is because of INSERT > statements. If I run application without writing into database memory is not > increasing. OS is linux and after 2 days system reboots because there is not > any more free memory for other application. I have read many forums and > websites but I havent found any solution to this. I also close and open > database after 1000 tranactions, but there is no improvance. Can you help > me? > > BR, Rose. > -- lp, Anže _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
