[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: The -hashLatchFactor parameter in Service Pack 11.7.3

  • Thread starter Thread starter Richard Banville
  • Start date Start date
Status
Not open for further replies.
R

Richard Banville

Guest
So the follow up to that is: In this new release, concurrent access to a single block (tiny data) will not be be improved (as it was with -lruskips). At most an individual block will never have more than one buffer pool hash table latch. Increaseing -latchHashFactor will not change that fact. However concurrent access to multiple differnet blocks is expected to be improved. For example: this mechanism is not intended to improve perfomance of 100 users cuncurrenly executing "repeat: find first customer" or even worse "repeat: current-value(seq1)" or "for each customer no-lock: end." when the customer table only contains one or two blocks. Such data access requires additional work to improve throughput from the storage engine perspective.

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