[progress Communities] [progress Openedge Abl] Forum Post: Re: Vst _areastatus Very Slow Access

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
> Wouldn't you get the same result with less fiddling and diddling by simply putting the schema area into B2? Yes, if the schema area contains only metaschema and db is using the -B2 and LRU mechanism is not enabled for alternate buffer pool - in other words, if a database is maintained in a right way. Dynamically allocated alternate buffer pool is just an alternate and "dynamic" solution (we can do it at any time when needed). And answer is NO for ACO blocks: we can't assign all of them to B2. BTW, I saw the cases when the blocks had the incorrect Lru flag in the buffer headers. The blocks that should be in the primary buffers had Lru 1. The blocks that belong to a table assigned to B2 had Lru 0. It was on sports db but I can't reproduce this behaviour right now.

Continue reading...
 
Status
Not open for further replies.
Back
Top