Kbase P123341: When using Type 2 storage areas, do whole area clusters load into the buffer pool?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/05/2010 |
|
Status: Unverified
GOAL:
When using Type 2 storage areas, do whole area clusters load into the buffer pool?
GOAL:
Do Type II storage areas cause entire clusters to load into memory?
GOAL:
Do single blocks load into memory when using Type 2 storage areas?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
The database engine will only load the blocks containing the data and indexes required, not the entire cluster of blocks.
For example, if an area had a 512 cluster size and the following command was run:
FIND FIRST orderline NO-LOCK.
It would read into memory maybe 2 or 3 blocks (index & data blocks), not 1024 blocks (2 clusters).