Product Documentation

c-treeACE V10.0 Update Guide

Previous Topic

Next Topic

Advances in Partitioned Files

The release represents a major engineering milestone related to our Partition File support. The ability to define criteria/rules that direct data I/O to separate physical data files (partitions) is a very powerful feature.

An extensive focus on performance has driven most of our efforts. Improvements in our internal index strategies resulted in significant performance overall.

Global unique indexes, range requests, alter table support, Windows/Unix time-stamp support, and partition administration have all been improved. These improvements are most evident while using our SQL layer over a partitioned file.

Partitioned Files

In This Chapter

Partitioned Files Available via c-treeACE SQL

Optimized c-treeACE SQL Partitioned File Queries

ALTER TABLE Add and Drop Columns Supported for Partitioned Files

Partitioning by Windows Date Values

Partition by Timestamp Rule Modified to Support GMT/UTC Time

New GETFIL() Modes to Retrieve First and Last Active Partition Members

c-treeDB .NET Interface Support for Partition File Management

c-treeDB Methods to Retrieve Partitions

Improved Rebuilding of Partitioned Files

Partitioned File Range Optimizations

Updated Partition Admin Modes Reuse and Base

PTADMIN() Partition Administration Purge

TOCIndex