data.db文件过大

[NoEggEgg]

目前data.db文件达到了2.51GB，应该是表x_search_files导致的，网页端是否可以增加清除按钮，目前应该如何处理

[blacklin]

用sqlite3打开data.db，执行 DELETE FROM x_search_files; 试试

[anwen-anyi]

x_search_files数据库表 有缓存应该是你开启搜索(enable search)导致的~
删除的话可以使用楼上的老哥方案试试，搜索功能处于实验室功能,还有就是你不用搜索功能建议关闭...QAQ
楼上老哥方案不行的话可以用navicat来链接打开然后选择删除数据也可以的.

[NoEggEgg]

一般电脑都不会装操作数据库的软件，我去试试，建议可以在网页端增加清除功能，方便一些。

[KinShin]

删除了相应的表也不会减少占用大小，因为 sqlite3 默认的 auto_vacuum 参数是 NONE。

The default setting for auto-vacuum is 0 or "none", unless the SQLITE_DEFAULT_AUTOVACUUM compile-time option is used. The "none" setting means that auto-vacuum is disabled. When auto-vacuum is disabled and data is deleted data from a database, the database file remains the same size. Unused database file pages are added to a "freelist" and reused for subsequent inserts. So no database file space is lost. However, the database file does not shrink. In this mode the VACUUM command can be used to rebuild the entire database file and thus reclaim unused disk space.

解决方法是手动执行 VACUUM 命令。