I've been intermittently looking at slow response times from our FB instance, even for 'simple' requests for a single bug. One thing I've noticed is that FB only ever seems to have four connections to MySQL (as shown in 'Server Connections' in MySQL administrator), and when I make multiple 'concurrent' requests from a single client (ie reload a bunch of tabs in my browser) then it looks as though all my requests are being channelled down a single MySQL connection.
What is the expected behaviour here? It might make sense to force a single user down a single MySQL connection to avoid DOS when a user makes a lot of requests, but for a server supporting ~30 users only 4 DB connections seems a bit limiting - it's easy to imagine that four users could be running 'complex' queries for a large number of bugs and thus significantly delay all other access...
I can't find anything in the FB/IIS/MySQL configurations to control the number of concurrent DB connections - but maybe I'm missing something?
Also, are there any good resources on sensible MySQL configuration on Windows for 'best' FB performance?