From fef63be10e793d0f551bdede7205e58829738d61 Mon Sep 17 00:00:00 2001 From: James Moger Date: Wed, 5 Nov 2014 08:51:34 -0500 Subject: Bump to 1.4.0-SNAPSHOT and update documentation --- src/main/java/com/iciql/Constants.java | 2 +- src/site/performance.mkd | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) (limited to 'src') diff --git a/src/main/java/com/iciql/Constants.java b/src/main/java/com/iciql/Constants.java index 82b6d79..30fcb77 100644 --- a/src/main/java/com/iciql/Constants.java +++ b/src/main/java/com/iciql/Constants.java @@ -25,7 +25,7 @@ public class Constants { // The build script extracts this exact line so be careful editing it // and only use A-Z a-z 0-9 .-_ in the string. - public static final String VERSION = "1.3.1-SNAPSHOT"; + public static final String VERSION = "1.4.0-SNAPSHOT"; // The build script extracts this exact line so be careful editing it // and only use A-Z a-z 0-9 .-_ in the string. 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. -- cgit v1.2.3