Subject Re: [firebird-support] Re: Firebird performance
Author Alexandre Benson Smith
Hi Stephen,

Stephen Boyd wrote:

>--- In, Alexandre Benson Smith
><iblist@t...> wrote:
>Thanks for your help. I never would have found this on my own.
Good that it helps, I really don't think it was the problem, but didn't
know either what could be.

>I dug up the FB 2 release notes and the description of this problem
>stated that it was a super server problem. I changed the
>installation to use classic and the problem seems to be gone.
>I've never used classic on Windows before. Anything special that I
>need to be aware of vis-a-vis, administration, tuning, etc?
I think you will have a better performance using CS on this SMP machine.

The only thing I could think about is that CS cache is per conection per
database instead of per database like in SS.

If you have a heavy load take a look on the Ann's excelent article
published on "The InterBase and Firebird Developer Magazine" about the
lock manager
The InterBase and Firebird Developer Magazine

see you and good luck !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil