At 05:33 24/09/2008, you wrote:

>The database in question handles connections from a variety of sources
>from sql queries run by ISQL from bash scripts to PHP on web /
>intranet servers and legacy Windows apps like MS Access & Visual basic
>programs.
>
>I suspect it is the interaction with MS Access that causes the most
>problems.
>
>However the problem is real.
>The classic server works without obvious slowdown all the way up to
>its ~ 60 user peak. Once past about a dozen users the superServer
>starts to stall.
>
>I can't attempt to diagnose the problem for obvious reasons.

1. What version of Firebird? If 2.0 or greater, what is the GCPolicy setting?
2. Describe "stall".
3. Provide gstat -h output taken when the system is busy and beginning to slow down.

./heLen