Partitioned Files
Use Cases
Quickly Purge Data
Archive Data
Partitioned Files Overview
Partitioned File Highlights
Prerequisites
Creating Partitioned Files
Managing Partitioned Files
Examples
Rules
Partitioned Files Available via FairCom DB SQL
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 Methods to Retrieve Partitions
c-treeDB .NET Interface Support for Partition File Management
Additional c-treeDB .NET CTTable.PartAdminByKey() Method
Advanced Concepts
Maximum Partition Number vs File Size
Raw Partition Numbers
Partitioned File Naming
Optimized FairCom DB SQL Partitioned File Queries
ALTER TABLE Add and Drop Columns Supported for Partitioned Files
Improved Rebuilding of Partitioned Files
Updated Partition Admin Modes Reuse and Base
Understanding FairCom's Partitioned File and FILESET Technologies
How Do Partition Files Compare to FILESETs?
Partitioned Files
FILESETs
Comparison Chart
How Does the Host File Appear to the Application?
Can We Perform Full-Text Search Queries on a Host File?
Can We Operate on a Single Member File Independently?
Can We Do a File Block on an Individual Member File?
Is It Possible to Add Extra User Fields to an Individual Member File?
Copyright Notice
Index
|