Subject | Re: [firebird-support] LockHashSlots |
---|---|
Author | Faisal Abdullah |
Post date | 2005-01-12T05:07:23Z |
Hi Ann,
Our DefaultDbCachePages is commented out. So i guess we're running a
default of 75 pages on our classic server. Is there a way to calculate
the optimized value for this?
Regards,
Faisal
On Mon, 10 Jan 2005 11:54:22 -0500, Ann W. Harrison
<aharrison@...> wrote:
Our DefaultDbCachePages is commented out. So i guess we're running a
default of 75 pages on our classic server. Is there a way to calculate
the optimized value for this?
Regards,
Faisal
On Mon, 10 Jan 2005 11:54:22 -0500, Ann W. Harrison
<aharrison@...> wrote:
> That's a problem. You've got the maximum number of hash slots and
> you've still got long chains. Just out of curiosity, how many page
> buffers are you using? Each page buffer in use is a lockable object,
> thus a lock block and a hash table entry.