Kbase P80179: Is it a risk having an AI and BI blocksize default of 8k?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Is it a risk having an AI and BI blocksize default of 8k?
FIX:
This solution is based on the solution 18293, discussing the risk having a db blocksize bigger than the filesystem one.
In fact, having a BI and AI blocksize default of 8k does not mean a risk due to the following facts:
-the AI and BI blocksizes can be changed afterwards
-active AI and BI themselves provide the best protection against data loss in case of a system failure (e.g. power problem).
-it is recommended to use AI and a lot of documented Progress security measures are given to minimize the risk mentioned in solution 18293.
-The Progress experience in the past underlines the performance aspect having 8k blocksizes with AI and BI and the mentioned risk factor can be controlled or being eliminated.