How can I improve performance of my application that uses JDataStore?

Abstract: 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.

Published on: 4/15/2007 6:56:45 PM

Server Response from: SC2