开发者

Why is my SQLite database bloated to 12MB (from 280KB) with single quotes?

开发者 https://www.devze.com 2023-03-08 14:54 出处:网络
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.

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

0

精彩评论

暂无评论...
验证码 换一张
取 消