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