Product Documentation

FairCom DB V12 Updates

Previous Topic

Next Topic

Increased PAGE_SIZE for Improved Performance

In this release the PAGE_SIZE has been increased from 8192 to 32767, yielding a 15% performance gain in our testing. This requires new transaction logs and rebuilding all existing indexes and superfiles.

Warning: Changing the PAGE_SIZE is a maintenance task that should be done carefully and with a full reliable backup. Practice on a copy of your data and server folder until you are confident with the results. For procedures, see Adjusting PAGE_SIZE in the FairCom Installation Guide.

Note: A file created with a larger PAGE_SIZE cannot be opened by a server with a smaller PAGE_SIZE.

TOCIndex