diff options
| author | Christian Grothoff <christian@grothoff.org> | 2018-12-11 19:27:34 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2018-12-11 19:27:34 +0100 |
| commit | c1dd4d02762d51d1ac4078407cda2796aff8faf4 (patch) | |
| tree | 612004af9190770e9c75235005873c92afc862c4 /src/namestore/plugin_namestore_sqlite.c | |
| parent | b362752b69f705754327dfb7e025260d97289ad9 (diff) | |
| download | gnunet-c1dd4d02762d51d1ac4078407cda2796aff8faf4.tar.gz gnunet-c1dd4d02762d51d1ac4078407cda2796aff8faf4.zip | |
cache NICK results in namestore to avoid unnecessary load on the DB; improve sqlite DB style, use WAL for sqlite DB
Diffstat (limited to 'src/namestore/plugin_namestore_sqlite.c')
| -rw-r--r-- | src/namestore/plugin_namestore_sqlite.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/namestore/plugin_namestore_sqlite.c b/src/namestore/plugin_namestore_sqlite.c index 23af3960d..e68a47a7b 100644 --- a/src/namestore/plugin_namestore_sqlite.c +++ b/src/namestore/plugin_namestore_sqlite.c | |||
| @@ -122,6 +122,7 @@ database_setup (struct Plugin *plugin) | |||
| 122 | GNUNET_SQ_make_try_execute ("PRAGMA auto_vacuum=INCREMENTAL"), | 122 | GNUNET_SQ_make_try_execute ("PRAGMA auto_vacuum=INCREMENTAL"), |
| 123 | GNUNET_SQ_make_try_execute ("PRAGMA encoding=\"UTF-8\""), | 123 | GNUNET_SQ_make_try_execute ("PRAGMA encoding=\"UTF-8\""), |
| 124 | GNUNET_SQ_make_try_execute ("PRAGMA locking_mode=EXCLUSIVE"), | 124 | GNUNET_SQ_make_try_execute ("PRAGMA locking_mode=EXCLUSIVE"), |
| 125 | GNUNET_SQ_make_try_execute ("PRAGMA journal_mode=WAL"), | ||
| 125 | GNUNET_SQ_make_try_execute ("PRAGMA page_size=4092"), | 126 | GNUNET_SQ_make_try_execute ("PRAGMA page_size=4092"), |
| 126 | GNUNET_SQ_make_execute ("CREATE TABLE IF NOT EXISTS ns098records (" | 127 | GNUNET_SQ_make_execute ("CREATE TABLE IF NOT EXISTS ns098records (" |
| 127 | " uid INTEGER PRIMARY KEY," | 128 | " uid INTEGER PRIMARY KEY," |