|
Pervasive PSQL v10 provides two types of data compression: record and page. Record compression was formerly termed "data compression."
Record compression and page compression may be used separately or together. The primary purpose for both compression types is to reduce the size of the data files and to provide faster performance depending on the type of data and on the type of data manipulation.
Record compression requires a file format of 6.0 or later. Page compression requires a file format of 9.5 or later.
Note that page compression is predominately a feature of the transactional interface. The relational interface supports page compression through the CREATE TABLE syntax.
See the following areas in the documentation for details about page compression.
|
Area of Discussion
|
Related Sections
|
|---|---|
|
Concepts
|
Record and Page Compression in Advanced Operations Guide
|
|
Maintenance utility
|
All references are to Advanced Operations Guide
|
|
BUTIL command-line utility
|
All references are to Advanced Operations Guide
|
|
Rebuild utility
|
Rebuild Utility GUI Reference in Advanced Operations Guide
|
|
Function Executor utility
|
All references are to Advanced Operations Guide
|
|
Pervasive PSQL Control Center
|
Table Properties in Pervasive PSQL User's Guide
|
|
Description file elements
|
Description File Elements in in Advanced Operations Guide
|
|
CREATE TABLE syntax
|
CREATE TABLE in SQL Engine Reference
|
|
SDK Changes
|
|
|
Chapter contents
Prev topic: Configuration Settings
|