What profiling of the sql pages has been done either via logging or with a profiler?
We haven't done any profiling, this was working in 3.2.1 just fine.
The only change is running it under 3.2.6RC2.
If profiling would help, I am not sure where to go with this... but if you could point me at a FAQ for setting it up and I will post the results.
Thanks for looking at this,
Go get a profiler. The following one is easy to use with jboss:
Otherwise enable trace level logging of the org.jboss category in the log4j.xml file and be sure to include the thread id using the %t option so that you can identify where the time in a request is spent.
This was very instructive, by looking at the traces we found a problem with our mySQL keep alive...
instead of an "are you there" we were asking for a complete dump of the DB.
so now we are trying to continue to squeeze every last bit of performance out of this solution, playing with the acceptCount and the maxProcessors to try to get the most robust results. Is there a best practice for setting these numbers? we want to be able to handle 100K+ users an hour.
Thanks in Advance,