OK, next step is to check the number of database connections you actually have. Easiest is if you are only using one datasource on that particular server, just run a netstat and check the number of TCP connections to port 5423. Else, start working from the database side, use the standard tools to determine the number of backends and their status. Alsomake sure you are not running with a default transaction level of serializable, which would make all transactions run pretty much after eachother.
We have 24 connections at the moment, as reported by the database. (can't use netstat because the CF server is running on the same machine as the database, so it's a unix socket rather than port 5423. Not running with serializable transaction level. ----------------------------- Stephen Richards 020 7903 3226 ------------------------------
