Product Documentation

c-treeACE V10.3 Update Guide

Previous Topic

Next Topic

Performance: Faster than Ever

FairCom continues to make performance improvements to put your application ahead of the competition. The gains are especially apparent when scaling across a large number of concurrent users on multi-CPU systems.

In addition, the V10.3 update to c-treeACE is providing enhancements to the c-treeACE SQL internal temporary memory allocation routines which will improve performance and enhance stability with complex and large queries.

See the section titled Performance Gains for more information.

Unix Shared Memory Enhancements

c-treeACE V10 introduced shared memory support on Unix systems to greatly improve the performance of localhost applications. Further improvements have been made to this functionality in V10.3.

See the section titled Improved and Expanded Shared Memory Support for more information.

Extended Data Compression Options

V10 introduced compression support; this release makes further advances to help you deal with today’s large data files.

  • A high-performance Run Length Encoding (RLE) algorithm is now available which outperforms zlib compression in many cases.
  • User-defined compression is available using a library you provide. With this feature, FairCom may be able to help you solve special requirements.
  • Compressed data files can now be compacted.

See the section titled Improved Compression Support for more information.

New Batch Update Functions

c-treeACE provides batch operations that have the potential to greatly improve performance when a group of related records needs to be processed. This release includes improvements to this feature that can result in greater efficiency.

See the section titled Batch updates for more information.

c-treeACE SQL Changes

Enhancements to the SQL interface include the improvements listed below to name just a few:

  • Removed SQL Statement Length Limits - V10.3 allows statement lengths up to 32MB for your most complex SQL statements.
  • c-treeACE SQL system tables are now encrypted by default to protect database meta data.

See the section titled c-treeACE SQL for more information.

Enhanced Deployment Flexibility with Environment Variable Support

The list of available c-treeACE options that can be configured through environment variables has been expanded.

See the section titled Configuration Flexibility with Environment Variable Support for more information.

Greater Connection Control Flexibility

c-treeACE now supports additional management for concurrent user accounts:

  • Limit ISAM vs. SQL Connections
  • Configurable c-treeACE SQL Server connection timeout

See the section titled Greater User Connection Control for more information.

Latest Platform Support

Continuing support for the latest platforms is included in this release. These include:

  • IBM AIX 7.1
  • Embarcadero RadStudio XE3 and XE4
  • Java 1.7 support

    Cross-Platform Java Tools

This release of c-treeACE includes graphical tools written in Java for cross-platform support. This support allows system administrators to leverage these powerful tools on any platform that supports c-treeACE and Java. Some of the tools have now been combined to simplify their operation. The following tools are available:

  • c-treeACE Explorer - Allows you to view and edit both SQL and ISAM databases in the same tool
  • c-treeACE Monitor - Gauges and statistics for visually monitoring your c-tree databases
  • Error Viewer - An updated version of the error viewer provides look-up and custom editing of error codes

See the section titled Introducing Cross-Platform Java Tools for more information.

TOCIndex