sqlite3配置项说明
目录
配置项 | 说明 | 取值 | 备注 |
---|---|---|---|
PRAGMA auto_vacuum | = NONE; 0 means disable auto vacuum | 只有在数据库中未建任何表时才能改变auto-vacuum标记 | |
= INCREMENTAL; 1 means enable incremental vacuum | |||
= FULL; means enable full auto vacuum | |||
PRAGMA cache_size | |||
PRAGMA case_sensitive_like | 大小写敏感 | 可设备不可读 | |
PRAGMA count_changes | |||
PRAGMA default_cache_size | |||
PRAGMA default_synchronous | |||
PRAGMA empty_result_callbacks | |||
PRAGMA encoding | |||
PRAGMA full_column_names | |||
PRAGMA fullfsync | |||
PRAGMA legacy_file_format | |||
PRAGMA locking_mode | |||
PRAGMA page_size | |||
PRAGMA max_page_count | |||
PRAGMA read_uncommitted | |||
PRAGMA short_column_names | |||
PRAGMA synchronous | |||
PRAGMA temp_store | |||
PRAGMA temp_store_directory |
说明
VACUUM
把空闲页移到数据库末尾,从而减小数据库大小。通过这样做,它可以明显地把数据库碎片化,而 VACUUM 则是反碎片化。所以 Auto-VACUUM 只会让数据库更小。VACUUM命令在auto-vacuum开启的数据库中不起作用。