diff options
author | Jürg Billeter <j@bitron.ch> | 2011-09-27 15:57:33 +0200 |
---|---|---|
committer | Martyn Russell <martyn@lanedo.com> | 2011-10-06 17:19:07 +0100 |
commit | 775ebd017320d0ce43cb8c126f18c4413ff7537c (patch) | |
tree | ed2c9bfb8f98edcdcffafe2261cbcf5fdcc5b531 | |
parent | 7bfd1b86ef8b4ffd5af66484a09eff9b322d1cb3 (diff) | |
download | tracker-775ebd017320d0ce43cb8c126f18c4413ff7537c.tar.gz |
libtracker-data: Set journal_size_limit to 10 MB
The WAL file may grow larger than that temporarily, but SQLite will
truncate it to 10 MB as soon as it can.
-rw-r--r-- | src/libtracker-data/tracker-db-manager.c | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/libtracker-data/tracker-db-manager.c b/src/libtracker-data/tracker-db-manager.c index c88a9603e..ca0f19b74 100644 --- a/src/libtracker-data/tracker-db-manager.c +++ b/src/libtracker-data/tracker-db-manager.c @@ -273,6 +273,8 @@ db_set_params (TrackerDBInterface *iface, /* disable autocheckpoint */ tracker_db_interface_execute_query (iface, NULL, "PRAGMA wal_autocheckpoint = 0"); + tracker_db_interface_execute_query (iface, NULL, "PRAGMA journal_size_limit = 10240000"); + if (page_size != TRACKER_DB_PAGE_SIZE_DONT_SET) { g_message (" Setting page size to %d", page_size); tracker_db_interface_execute_query (iface, NULL, "PRAGMA page_size = %d", page_size); |