Subject | Re: [firebird-support] Re: Firebird performance |
---|---|
Author | Ann W. Harrison |
Post date | 2005-11-22T21:54:58Z |
Stephen Boyd wrote:
fb_lock_print to check the lock table usage. If the hash lengths are
more than min: 2 avg: 6 max: 15, increase the parameter LOCK_HASH_SLOTS
in the configuration file to a prime number less than 2048.
Regards,
Ann
> I've never used classic on Windows before. Anything special that IUse a reasonable number of buffers per process - try 200 to start. Use
> need to be aware of vis-a-vis, administration, tuning, etc?
fb_lock_print to check the lock table usage. If the hash lengths are
more than min: 2 avg: 6 max: 15, increase the parameter LOCK_HASH_SLOTS
in the configuration file to a prime number less than 2048.
Regards,
Ann