Subject Re: [firebird-support] SortMemBlockSize/SortMemUpperLimit settings
Author Alexandre Benson Smith
rogerpullen wrote:
> All
> FB 1.5 on a W2003 server with 2GIG RAM - we are having performance
> issues and am wondering if there is their any benefit of increasing the
> SortMemBlockSize or SortMemUpperLimit parameters in firebird.conf. I
> have read the "book" but want to understand the implications a bit
> better . We normally have about 70 user logged on and believe it is
> excessive reporting that is the culprit
> Connections are via delphi/IBO
> Regards
> Roger

Not an answer to your question, but a point to consider:

You could try CS, CS spans a process for each connection, and the OS
scheduler could do a better job spliting the CPU time across the
connections than the SS do.

see you !

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