Hi Jay, Thanks for your response and it is the cache as you say. After ~ 150 inserts memory stabilises thereafter. This equates approx to the 2000 cache pages. Thanks again. John D. > Using SQLite3 3.5.9, I am seeing a consistent rise in memory with each > > call to sqlite3_step(). >> Jay A. Kreibich wrote: >> I'd assume it is the normal cache behavior. By default, SQLite>> database >> pages are 1K and the max page cache is 2000, using a total>> of about 3MB of >> RAM (each page as a ~0.5K overhead).>> >> You could try a lot more queries >> and see if things level out and/or>> lower the cache limit via PRAGMA. _________________________________________________________________ Get 30 Free Emoticons for your Windows Live Messenger http://www.livemessenger-emoticons.com/funfamily/en-ie/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
