![](space.gif) Introduction
![](plus.gif) V11: One Database. Countless Possibilities.
![](space.gif) FairCom and Current Database Technology Trends
![](space.gif) Great Performance News for OLTP Applications
![](space.gif) Replication and Distributed Servers
![](space.gif) No+SQL Integration Enhancements
![](space.gif) Latest c-treeACE SQL Features
![](space.gif) Added Conditional Expression Support for Partitioned Files
![](space.gif) Java Family Expands
![](space.gif) Advanced Full-Text Search Indexing
![](space.gif) Deferred File and Index Maintenance
![](space.gif) Coordinate Application Recovery with Transaction Restore Points
![](space.gif) Browser-Based Administration Tools
![](space.gif) Many Other Requested Features
![](plus.gif) V11 Performance Gains
![](plus.gif) Delayed Durability Transaction Log Mode for Performance
![](space.gif) Performance Gains
![](space.gif) Modified Log Sync Strategy
![](space.gif) Delayed Durability Behavior
![](space.gif) Monitoring Delayed Durability Performance
![](space.gif) Time limit on flushing updated data and index cache pages for TRNLOG files
![](space.gif) Controls for Performance AND Safety of Non-Transaction Updates
![](space.gif) Linux Direct I/O (UNBUFFERED I/O) Performance Support
![](space.gif) COMMIT_DELAY Configuration Now Defaults to 1 ms on Linux Systems
![](space.gif) Faster Open of c-treeDB Tables
![](space.gif) Data Record Compression Optimization
![](space.gif) Use of Domain Sockets for Faster Unix/Linux Shared Memory Connections
![](space.gif) Improved Unix Performance with Shorter Adaptive Defer for Index Node Retrievals
![](space.gif) Improved Performance of Failed Batch Inserts with Savepoint Restores
![](space.gif) Improved Index Update Performance
![](space.gif) SQL Speed-Up
![](plus.gif) c-treeACE Replication Solutions
![](space.gif) Replication for Every Need
![](plus.gif) Replication Manager
![](space.gif) Replication Agent - File Notification Queue Events
![](space.gif) Replication Agent - c-tree DB Engine notification
![](plus.gif) Replication Agent - The Next Generation
![](space.gif) Directly Set a Replication Agent Start Position
![](space.gif) Associate Replication to Specific Server Nodes
![](space.gif) External Notification of Replication Agent Events
![](space.gif) Configurable Timeout for Replication Agent Network Calls
![](space.gif) Correctly Terminate Orphaned Replication Agent Source and Target Server Connections
![](space.gif) ctrepd Replication Debug Utility
![](space.gif) Improved Error Handling for Replication Agent HTRN_ERR (520)
![](space.gif) Support Partial Record Rewrite in Local/Master Synchronous Replication
![](space.gif) Improved Responsiveness of the c-treeACE Replication Monitor
![](plus.gif) No+SQL Data Access
![](space.gif) c-treeACE No+SQL Solutions
![](space.gif) c-treeACE SQL FILESET for Dynamic Joining of Physical Data Files
![](space.gif) c-treeACE SQL Data Arrays™ for Sub-Record Data
![](space.gif) Cutting-Edge No+SQL Features
![](plus.gif) c-treeACE SQL Features
![](space.gif) New Stored Procedure Development Frameworks
![](space.gif) SQL Group Support for User Role Management
![](space.gif) c-treeACE SQL Entity Framework 6 Support with ADO.NET
![](space.gif) Table Valued Functions
![](space.gif) Extended ALTER VIEW, ALTER TABLE, and ALTER INDEX Flexibility
![](space.gif) Common Table Expressions (CTE) and Recursive Queries
![](space.gif) LOCK TABLE Statement Added
![](space.gif) Scrollable SQL Cursors
![](space.gif) Unicode default charset for SQL CHAR and VARCHAR changed from US-ASCII to ISO-8859-1
![](space.gif) Allow DOUBLE as an alias for DOUBLE PRECISION data type
![](space.gif) Configuration Options for c-treeACE SQL LATTE Subsystem
![](plus.gif) Extended c-treeACE SQL Stored Procedure Frameworks
![](plus.gif) c-treeACE SQL Stored Procedure Development in the .NET Framework
![](space.gif) Visual Studio .NET Development
![](plus.gif) Preparing to Write a .NET SP, UDF, or Trigger
![](space.gif) Writing a New SP, UDF, or Trigger
![](space.gif) Deploying the SP, UDF, or Trigger
![](space.gif) Testing the SP, UDF, or Trigger
![](space.gif) Debugging the SP, UDF, or Trigger
![](space.gif) Altering the SP, UDF, or Trigger
![](space.gif) Writing the Code
![](space.gif) Returning a Result Set from a Stored Procedure
![](space.gif) Returning a UDF Result
![](space.gif) Accessing Old and New Rows in Triggers
![](plus.gif) NetBeans Plugin for Java Stored Procedure Development
![](space.gif) Installing the NetBeans Plugin
![](space.gif) Setting up the Connection to the Server
![](space.gif) Editing Stored Procedures
![](space.gif) Enabling Debugging
![](space.gif) c-treeACE SQL Deployment Utilities for Stored Procedures, UDF, and Triggers
![](plus.gif) User-Defined Partitioned File Conditional Expressions
![](space.gif) User-Defined Conditional Expressions for Easy Partitioned File Creation
![](space.gif) Conditional Expressions and Partition Rules
![](space.gif) Partitioned Files in c-treeACE SQL
![](space.gif) c-treeDB Partition File API Support
![](space.gif) c-treeACE ISAM Usage
![](space.gif) Managing Partitions
![](plus.gif) c-treeACE Java Edition Solutions
![](space.gif) Everything for Java
![](space.gif) Java Persistence API (JPA) with c-treeACE
![](space.gif) Enterprise Java Beans
![](space.gif) c-treeACE JDBC
![](space.gif) c-treeDB Java
![](plus.gif) New Deferred File and Index Maintenance
![](plus.gif) Deferred Indexing
![](space.gif) Queuing an Index Load
![](space.gif) Counting the Number of Deferred Operations
![](plus.gif) Asynchronous Record Update Notifications
![](space.gif) Update Callback Specifications
![](plus.gif) Coordinate Application Recovery with Transaction Restore Points
![](space.gif) Transaction Restore Points
![](space.gif) Creating Restore Points
![](plus.gif) Rolling Back to a Restore Point
![](space.gif) SYSLOG Logging of Restore Point
![](space.gif) Temporary Event File
![](space.gif) Using ctalog SYSLOG Utility to Read Restore Point Data
![](space.gif) Automatic Recovery Considerations
![](space.gif) Rollback to New Restore Points with ctrdmp
![](space.gif) Restore Points as an Incremental Roll Forward Strategy
![](space.gif) Restore Point Files
![](space.gif) Restore Point Limitations
![](plus.gif) Embedded Web Server for Browser Based Administration
![](space.gif) A c-treeACE SQL Explorer for Your Web Browser
![](plus.gif) Extended c-treeACE Features
![](space.gif) Millisecond Timestamp Resolution Support
![](space.gif) Table Lock Support
![](space.gif) IPv6 Support
![](space.gif) ReFS
![](space.gif) Prevent ISAM Index Key Value Updates
![](space.gif) Automatic Directory Creation for New Files
![](space.gif) Extended c-treeDB Default Field Value Support
![](space.gif) Retrieve Current Server Date and Time
![](space.gif) User-Defined Function for Conditional Expressions
![](space.gif) System Group Assignment of Unix/Linux Shared Memory resources
![](space.gif) Specify Shared Memory Keys on Unix
![](space.gif) FairCom Server - Configuration option to disable delete node thread
![](plus.gif) Monitor c-treeACE Memory Use and Suballocator List Allocation Call Stacks
![](space.gif) Memory Tracking with c-treeACE on Linux
![](space.gif) Unicode Support
![](space.gif) Latest Microsoft Visual Studio 2015 Support
![](plus.gif) Additional File Management Options
![](space.gif) Copy Files Between c-treeACE Servers
![](space.gif) File Copy Wrapper API Functions
![](space.gif) Verify Data and Index File Integrity
![](space.gif) Delete Node and Space Reclamation Threads no Longer Preclude File Access
![](space.gif) Toggle Serial Segment (SRLSEG) Support for Files
![](plus.gif) New File Descriptor Operational Parameters
![](space.gif) Improved File Descriptor Limit Messages Logged During Server Startup
![](space.gif) Server Now Fails to Start if File Descriptor Limit Can't be Increased to Required Value
![](space.gif) Message Written to Standard Output When File Descriptor Limit is too Low
![](space.gif) New file descriptor limit compatibility keyword
![](plus.gif) Advanced Data Integrity Controls
![](space.gif) Linux File System Performance and Safety
![](space.gif) Flush KEEPOPEN Files to Disk With Last File Close for Enhanced Data Integrity
![](space.gif) LOKREC() modes to unlock all records in all files of the specified type that are open by the caller
![](space.gif) Prevent ISAM Index Key Value Updates
![](space.gif) New ctFeatKEEP_XFREED Lock Mode to Mark Entires in User Lock Table for Unlock Requests During a Transaction
![](space.gif) Flush Directory Metadata to Disk for Transaction-Dependent File Creates, Deletes and Renames
![](space.gif) Permit ADMIN Group Member Access to Files with Corrupt Resource Chains
![](plus.gif) Security Controls
![](space.gif) LDAP Authentication Controls and Group Support
![](space.gif) Added Restrictions on Advanced Encryption Master Key Configuration Options
![](plus.gif) Interface Technology Additions
![](space.gif) Overview of Current c-treeACE Interface Technology
![](plus.gif) c-treeACE NoSQL ISAM APIs
![](space.gif) FairCom.CtreeDb - Added ServerDateTime methods
![](space.gif) c-treeDB for Java Now Supports MRT Tables
![](space.gif) c-treeDB - New key type for Deferred Index
![](space.gif) c-treeDB Callback Updates for Types SDK
![](space.gif) c-treeDB Default Field Types Added
![](space.gif) GetServerDateTime() Added to c-treeDB for Java
![](space.gif) Table Lock Mode for LOKREC
![](space.gif) New Xtd8 File Mode to Automatically Create Directories
![](space.gif) ctCopyFile
![](space.gif) ctRecordUpdateCallbackControl
![](space.gif) ctDeferredIndexControl
![](space.gif) ctThrdSharedCritical API for Scalable Read Locks
![](space.gif) ctVerifyFile
![](space.gif) CloseConnection API Function to Cleanly Shut Down a Forked Connection
![](space.gif) ctfcpFreeHandle
![](space.gif) ctfcpAddFileCopyOperation
![](space.gif) ctfcpAllocateHandle
![](space.gif) ctfcpRemoveFileCopyOperation
![](space.gif) ctfcpSetErrorBuffer
![](space.gif) ctfcpGetErrorBuffer
![](space.gif) ctfcpSetCallback
![](space.gif) ctfcpSetCopyOptions
![](space.gif) ctfcpSetCopyFilenames
![](space.gif) ctfcpSetCopyFilePassword
![](space.gif) ctfcpSetServerParameters
![](space.gif) ctfcpCopyFile
![](plus.gif) c-treeACE SQL APIs
![](space.gif) Database Management Methods Added to ADO.NET Data Provider
![](space.gif) JDBC - Character Set Can Now Be Specified in the Connection URL
![](space.gif) c-treeACE SQL JDBC Now Allows Specifying User and Password in Connection URL
![](space.gif) c-treeACE SQL ODBC Ability to Set Query Timeout in DSN and Connection String
![](space.gif) c-treeACE SQL ODBC Ability to Set "Default Fetch Size" in DSN or Connection String
![](space.gif) c-treeACE SQL ODBC Unix ODBC driver for AIX and Solaris
![](space.gif) c-treeACE SQL Direct SQL ctsqlGetParameterName()
![](space.gif) c-treeACE SQL Direct SQL ctsqlIsParameterNull
![](space.gif) c-treeACE SQL Direct SQL ctsqlGetNumericParameterAsString
![](space.gif) c-treeACE SQL Direct SQL sqlda cursors
![](space.gif) Embarcadero (Borland) XE - Support for 64-bit VCL Drivers
![](plus.gif) Latest News for GUI Tools
![](space.gif) Latest in Tools Development
![](space.gif) Browser Based c-treeACE SQL Explorer
![](space.gif) c-treeACE Monitor
![](space.gif) c-treeACE SQL Explorer
![](space.gif) c-treeACE SQL Query Builder
![](space.gif) c-treeACE ISAM Explorer
![](space.gif) c-treeACE Gauges
![](space.gif) c-treeACE Security Administrator
![](space.gif) c-treeACE Explorer
![](space.gif) c-treeACE Monitor
![](space.gif) Dr. c-tree
![](space.gif) c-treeACE Replication Monitor
![](space.gif) And More Tools...
![](plus.gif) Command-Line Utility Updates
![](space.gif) Command-Line Tools for Administrators
![](space.gif) FILESET host creation utility
![](space.gif) dfkctl - Deferred Index Maintenance Utility
![](space.gif) ctcompare - Database Comparison Tool
![](space.gif) Rollback to New Restore Points with ctrdmp
![](space.gif) Header Record Counts Output with ctinfo c-tree Information Utility
![](space.gif) Replication Actions Added to Transaction Control Utility cttrnmod
![](space.gif) ctTRANMODE Control Added to Transaction Control Utility cttrnmod
![](space.gif) Replication Debug Utility Timestamps Displayed in Local Time Format
![](space.gif) Replication Debug Utility Options to Specify User Name and Password
![](space.gif) Limit Replication Debug Utility Output to Specific Files
![](space.gif) New File Verification Utilities - ctflvrfy.exe, ctvfyfil.exe, ctvfyidx.exe
![](space.gif) Advanced encryption master key store encrypted at system level on Windows
![](plus.gif) Critical Production Updates
![](space.gif) Corrected Unhandled Exception When File Password Included in Open File Call
![](space.gif) Corrected Read and Write Errors after Connection Termination
![](space.gif) Prevent FairCom Server WRITE_ERR Termination with Open Transactions Aborted by Quiesce
![](space.gif) Corrected Unexpected FairCom Server Internal Error 7495 Crash
![](space.gif) Prevent c-tree Server Unhandled Exception During Update of Compressed Record
![](space.gif) Inconsistent FPUTFGET Header Locking for Non-HUGE Index Files and Variable-Length Data Files
![](space.gif) Avoid FairCom Server Termination with Internal Error 8987 When Using UNBUFFERED_IO Configuration Option
![](space.gif) Prevent Unhandled Exception When a Single Connection Opens a File More than 1024 Times
![](space.gif) Corrected Prime Cache Thread Unhandled Exception When Opening File Pending Delete
![](space.gif) Corrected Errors When Changing a Temporary Index Condition
![](space.gif) Deadlock Corrected in Data Cache Retrieval Function
![](space.gif) Unhandled Exception When Accessing Pruned Memory Index Node
![](plus.gif) Notable Compatibility Changes
![](space.gif) FairCom Server - Change defaults for V11 release
![](space.gif) Correct Error Messages Now Returned by fc_create_user Procedure
![](space.gif) SQL - Changed error message for error -20139
![](space.gif) SQL - BINARY fields not padded with 0x00
![](space.gif) SQL - Binary Literals
![](space.gif) Automatic c-treeDB Batch Buffer Resize
![](space.gif) Proper positioning of ctdbSeekRecord with active record sets
![](space.gif) Server process exit code more informative
![](space.gif) Physical read of variable-length transaction controlled file skips records added by a third-party transaction not yet committed
![](space.gif) Linux File System Performance and Safety
![](space.gif) COMMIT_DELAY Configuration Now Defaults to 1 ms on Linux Systems
![](space.gif) Relaxed COMPATIBILITY FORCE_WRITETHRU Defaults
![](space.gif) New Extended Data Types Support
![](space.gif) Dynamic Dump Stream Files No Longer Segment by Default
![](space.gif) Auto-Numbering Replication Defaults Changed
![](space.gif) “Add Unique Keys First” Feature Applied to ctADD2END Files
![](space.gif) Maximum LIST_MEMORY Setting Increased to 10MB
![](space.gif) Maximum Index Members per File (MAXMEMB)
![](space.gif) Maximum Number of Indexes per Data File (MAX_DAT_KEY) Default Increased to 64
![](space.gif) Maximum Number of Open Files per User (MAX_FILES_PER_USER) Default Increased to 32767
![](space.gif) Allow a Single Byte or SByte to be passed as a BINARY Value in ADO.NET
![](space.gif) c-treeACE Memory Allocation Limit Disabled
![](space.gif) c-treeACE SQL SETENV limit raised to 8192
![](space.gif) c-treeACE SQL Stored Procedure Server-side Debugging Options
![](space.gif) Java Stored Procedure Runtime Classes no Longer Require ctreedbs in Path
![](space.gif) PHP - Components Now Match non-Thread-Safe Defaults for Windows IIS PHP Installations
![](space.gif) c-treeACE SQL JDBC Socket Timeout Defaults to 0
![](space.gif) c-treeACE JDBC Java 1.5 Compatible Driver Availability
![](space.gif) Windows Servers Now Statically Linked with ZLIB Compression Libraries
![](space.gif) Document History
![](space.gif) FairCom Typographical Conventions
![](space.gif) Copyright Notice
![](space.gif) Index
|