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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br