c-treeACE SQL Enhancements

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

Performance Enhancements

Huge Performance Gains in Complex Query Performance
Query Timeout Option to Prevent Long Running Queries
Diagnostic Logging of Query Times

Utilities

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.

c-treeACE SQL Reference Guide

c-treeACE SQL Java Stored Procedures, Triggers and User Defined Functions Guide

c-treeACE SQL ODBC Developer’s Guide

c-treeACE SQL JDBC Developer’s Guide

c-treeACE SQL ISQL Tools and Reference Guide

c-treeACE SQL ADO .NET Data Provider Developer’s Guide

c-treeACE SQL PHP Developer’s Guide

c-treeACE SQL Direct SQL Developer’s Guide

c-treeDBX Developer’s Guide