diff options
| author | James Moger <james.moger@gitblit.com> | 2014-11-05 08:51:34 -0500 |
|---|---|---|
| committer | James Moger <james.moger@gitblit.com> | 2014-11-05 08:51:34 -0500 |
| commit | fef63be10e793d0f551bdede7205e58829738d61 (patch) | |
| tree | 64ee5aa51d517635b756709bc42ae579c04bbf03 /src/site | |
| parent | 6f486197c5aae3246e8175b828fe3e4c8de3906d (diff) | |
| download | iciql-fef63be10e793d0f551bdede7205e58829738d61.tar.gz iciql-fef63be10e793d0f551bdede7205e58829738d61.zip | |
Bump to 1.4.0-SNAPSHOT and update documentation
Diffstat (limited to 'src/site')
| -rw-r--r-- | src/site/performance.mkd | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/site/performance.mkd b/src/site/performance.mkd index 671345e..3ef2451 100644 --- a/src/site/performance.mkd +++ b/src/site/performance.mkd @@ -13,6 +13,8 @@ The following data was generated by running the *single-threaded* iciql test sui Connections are pooled to normalize embedded database performance with out-of-process database performance. Some of the Java embedded database configurations have a very high startup-time penalty. Notably, H2 is slow to open a database and its performance is substantially affected if connection pooling is not enabled to keep the embedded database open.
+SQLite uses the default [DELETE journaling mode](https://www.sqlite.org/lockingv3.html#rollback). About a 4x performance improvement can be achieved when using the [WAL journaling mode](https://www.sqlite.org/wal.html) (`PRAGMA journal_mode = WAL`).
+
External process databases (MySQL & PostgreSQL) use the default settings as provided by the platform.
All tables are created as CACHED when the database distinguishes between CACHED and MEMORY tables.
|