|
|
|
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 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
