FairCom Database Engine Partitioned Files

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 FairCom DB API Methods to Retrieve Partitions FairCom DB API .NET Interface Support for Partition File Management Additional FairCom DB API .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