summaryrefslogtreecommitdiffstats
path: root/docs/03_performance.mkd
diff options
context:
space:
mode:
Diffstat (limited to 'docs/03_performance.mkd')
-rw-r--r--docs/03_performance.mkd2
1 files changed, 1 insertions, 1 deletions
diff --git a/docs/03_performance.mkd b/docs/03_performance.mkd
index 12c07a1..377d222 100644
--- a/docs/03_performance.mkd
+++ b/docs/03_performance.mkd
@@ -9,7 +9,7 @@ Performance of iciql statement generation is not currently benchmarked.
### iciql+database performance comparison
-The following data was generated by running the *single-threaded* iciql test suite. All database connections are pooled and re-used within each execution of the test suite using [Apache Commons DBCP](http://commons.apache.org/dbcp).
+The following data was generated by running the *single-threaded* iciql test suite. All database connections are pooled and re-used within each execution of the test suite using [Apache Commons DBCP](http://commons.apache.org/dbcp). All tables are created as CACHED when the database distinguishes between CACHED and MEMORY tables.
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.