PreviousWhat's New in Pervasive PSQL v10 (v10) Next

Page Compression

Chapter contents

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.

Additional Reading

See the following areas in the documentation for details about page compression.

Table 1-6 Page Compression References  
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
Book contents

Prev topic: Configuration Settings
Next topic: Access Methods (Software Development Kit)