Features

• Provides high-speed, multi-user local and network access to the data and index files used by CA-Clipper (.DBF/.DBT/.NTX/.NSX), FoxPro (.DBF/.FPT/.IDX/.CDX), as well as HiPer-SIx (.DBF/.SMT/.NSX) index and memo data files.
• High speed access - traverse a 1 million record table in less than 1 second.
• Small footprint with less than 500kb of distributable files.
• Supports large data files that are 100's of MB in size.
• High-speed searching using optimized indexes can find any record instantly.
• Easy-to-use and easy-to-deploy.
• JET, ODBC, BDE and ADO not required.
• With the Apollo SQL™ add-on, developers can use SQL in local mode.
• Client/server ready! Seamless Client/Server migration to the Apollo Server. Add client/server support by connecting to Apollo Server using the exact same code set for local and network configurations.
• No end-user configuration required.
• File-level data encryption.
• File and record-level locking for both Windows and DOS simultaneous transactions.
• Built-in Mach SIx Query Optimizer - Similar to Microsoft's RushMore Technology used in FoxPro and MS-Access - allows filters and non-SQL queries to execute at blazing speeds.
• Index Scoping - Limit your indexed views in a flash!
• User-Defined Function (UDF) support in index/query expressions.
• Roll-Your-Own (RYO) Queries and Indexes - Completely ad-hoc queries with no fixed condition!
• Flip existing indexes between ascending and descending order.
• Conditional Indexing allows indexes to selectively included data.
• Low-level power using direct calls to the SDE API functions.
• Includes Fast Text Search (FTS) component which is a powerful search engine that provides hyper-fast searches on text-based databases similiar to the Find option in the Windows help system.