Subject Re: [firebird-support] Re: Firebird performance
Author Ann W. Harrison
Stephen Boyd wrote:

> I've never used classic on Windows before. Anything special that I
> need to be aware of vis-a-vis, administration, tuning, etc?

Use a reasonable number of buffers per process - try 200 to start. Use
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