I'm using SQLiteManager. I had a 280KB database that bloated to over 12MB in just one day. I wasn't doing anything atypical. I still only have about 4-6 light results in the entire database.
When I open up the database file with a text editor, I see 开发者_C百科pages upon pages of single quotes (').
Also, SQLiteManager injects dozens of single quotes directly into the TinyText attributes that I have every now and then. This is visible on SQLiteManager's Web UI.
Any ideas as to what's going on?
Whatever SQLiteManager is doing, can you have it run VACUUM? If that frees the space, you can then have it run periodically; see this link for more information:
http://www.sqlite.org/lang_vacuum.html
Also, you can set auto_vacuum to FULL:
http://www.sqlite.org/pragma.html#pragma_auto_vacuum
精彩评论