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

Reply via email to