Boost the Performance of Your c-tree Server

The c-tree Server is optimized for performance out of the box. By intelligently tuning an array of parameters, you can often obtain additional performance! Scalability, rock solid stability, and a huge array of features for every conceivable need are what you find when you put c-tree Plus to work for you.

How can you gain this performance in your application? Review the following performance enhancing options available with the V8.14 c-tree Server and c-treeSQL Server. Need even more performance? Put our engineering team to work with your team and watch how fast c-tree can go!

c-tree Server V8.14 Performance Features

• The c-tree Server defaults to TCP/IP communication between clients and the server. Read the following for those cases where a shared memory protocol could boost your throughput.

  Client/Server Communications and Performance

• Flushing files to disk is an expensive I/O operation. FairCom has extensively profiled various options for flushing data to disk. The following two sections offer advanced c-tree Server V8.14 options to tailor performance for your transaction volumes.

  Reduced Flushing of Updated Data and Index Cache Pages

  More Efficient Flushing of Files

• Creating new transaction logs can place a heavy I/O load on the c-tree Server. Additional options are available to reduce the impact of this operation and are described as follows.

  More Efficient Creation of Transaction Logs

• To maintain a balance of shorter automatic recovery times versus online transaction performance, the c-tree Server periodically checkpoints the transaction logs. This checkpoint operation can be tuned for best performance.

  More Efficient Transaction Checkpoints

• c-tree Plus provides powerful transaction capabilities, including multiple savepoints and rollbacks. Replace Savepoint is an advanced feature used within the c-tree Server to achieve faster performance. This c-tree Plus function is available for use within your application to take advantage of the improved efficiency.

  Efficient Single Savepoint for Large Transactions

• In almost all instances, more cache is better. The V8.14 c-tree Server makes it easier to specify larger cache sizes for your data and index files.

  Configuring Large Cache Sizes

• Do you start transactions that ultimately do not involve an update? You might want to consider our smarter transaction control with deferred Begin handling.

  Deferred Flush of Transaction Begin

Enhanced Default Configuration Files

To get you started with all of the performance options described in this eNewsletter edition, we have made available enhanced default c-tree Server configuration files for you to include in your performance profiling. Select your platform below to download a fresh configuration file and begin testing today!

• ctsrvr.cfg.windows
• ctsrvr.cfg.unix