On Dec 17, 2009, at 10:53 AM, Kavita Raghunathan wrote: > > Thanks for the reply. You are right we should VACUUM in cases where > we are > removing items. But, this question is not about removing. > This question is about a fully populated database and it seems > bloated to be > occuping 3 times the memory. Maybe this amount of memory is considered > normal since we are using SQL and sqlite. Just wanted to check if > that is in > fact the case.
Did you run the "sqlite3_analyzer.exe" utility on your database file to see how disk space is being used? Get a copy from the Download page on the SQLite website. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users