[All]
Improving JDataStore performance.
Abstract: Improving JDataStore performance.
How can I improve performance of my application that uses JDataStore?
- Perform commits only when needed. This operation forces the logfile entries up to the commit point to disk;
- Use the saveMode property of the DataStore component to control how often cache blocks are written to disk. This property applies only to non-transactional DataStores;
- Setting the DataStore.tempDirName property, used by the query engine, to a directory on another (fast) disk drive may help;
- Try setting the TxManager.checkFrequency higher. Higher values will result in slower recovery;
- Set the autoCommit property to true;
- For transactions that are reading but not writing, significant performance improvements can be realized by using a read-only transaction. The DataStoreConnection's readOnlyTx property controls whether a transaction is read-only. This property must be set to true before the connection is open;
- Make use of setSaveInterval(long interval) to control the checkpoint frequency.
