FairCom DB 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 FairCom DB 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 FairCom DB SQL Clients
FairCom DB 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 Searching 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
FairCom DB ISAM to SQL Migration Toolkit
Many More ...
Complete Online Documentation
Complete information for all of the updated FairCom DB SQL features are available in the updated manuals available online.