aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJames Ahlborn <jtahlborn@yahoo.com>2012-02-08 13:35:44 +0000
committerJames Ahlborn <jtahlborn@yahoo.com>2012-02-08 13:35:44 +0000
commitc73696764c1bf5a557b7b408140f5cfccf5e6900 (patch)
tree274af1e9912b32cbc002f38503766211a02808ec
parente5a045f24eab4a8010eb13ad6f6257e644e87324 (diff)
downloadjackcess-c73696764c1bf5a557b7b408140f5cfccf5e6900.tar.gz
jackcess-c73696764c1bf5a557b7b408140f5cfccf5e6900.zip
update faq
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@613 f203690c-595d-4dc9-a70b-905162fa7fd2
-rw-r--r--src/site/fml/faq.fml24
1 files changed, 16 insertions, 8 deletions
diff --git a/src/site/fml/faq.fml b/src/site/fml/faq.fml
index 2b4d2d9..7333143 100644
--- a/src/site/fml/faq.fml
+++ b/src/site/fml/faq.fml
@@ -143,14 +143,22 @@
<question>Why is jackcess so slow for large updates?</question>
<answer>
<p>
- While there is much room for improvement in update speed, one factor
- is whether or not all writes are automatically forced to disk. By
- default, "autoSync" is enabled, which keeps the database file in a
- more consistent state, but can be very slow for large updates.
- Disabling "autoSync" can dramatically increase update speed, but
- exceptions during update can leave the file in an unusable state.
- So, modifying this option essentially trades off speed for
- recoverability.
+ In general, the focus of Jackcess is functionality, not speed.
+ However, one major speed factor is whether or not all writes are
+ automatically forced to disk. By default, "autoSync" is enabled,
+ which keeps the database file in a more consistent state, but can be
+ very slow for large updates. Disabling "autoSync" can dramatically
+ increase update speed, but exceptions during update can leave the
+ file in an unusable state (when disabled, you can call <a href="apidocs/com/healthmarketscience/jackcess/Database.html#flush()">Database.flush()</a> manually to force updates to disk). Modifying this option essentially
+ trades off speed for recoverability.
+ </p>
+ <p>
+ Additionally, <a href ="apidocs/com/healthmarketscience/jackcess/Table.html#addRows(java.util.List)">adding rows in batches</a> instead of one at a time can
+ increase insert speed.
+ </p>
+ <p>
+ Finally, always make sure you are using the <a href="https://sourceforge.net/projects/jackcess/files/latest/download">latest release</a>, as speed
+ improvements are happening periodically.
</p>
</answer>
</faq>