c-treeACE SQL has undergone extensive enhancements in both performance and features. The query optimizer engine underwent a major analysis and many queries now run exponentially faster. Many language constructs were added to make c-treeACE SQL more flexible than ever as well. Additional scalar functions provide convenient operations with data of all types.
New and Enhanced Functionalities
Stored Procedures, Triggers, and User Defined Functions are Included by Default
Included Built-In Stored Procedures
Improved Stored Procedure Handling
Automatic Shared Memory Protocol with Local Windows Clients
FairCom Security Handshake for c-treeACE SQL Clients
c-treeACE SQL Client Connection and Login Timeout Support
Advanced Encryption for Tables
A new TRUNCATE Table function
Now Supports Transaction Isolation Levels 1 and 2
Many New Scalar Functions
Advanced Seaching of LVARCHAR Fields with the CONTAINS Clause
Complete RIGHT OUTER JOIN Syntax Added
Huge Performance Gains in Complex Query Performance
Query Timeout Option to Prevent Long Running Queries
Diagnostic Logging of Query Times
Utility Option to Copy a Database
Types SDK for ISAM Compatibility
c-treeACE ISAM to SQL Migration Toolkit
Many More ...
Complete Online Documentation
Complete information for all of the updated c-treeACE SQL features are available in the updated manuals available online.