I have a
Java Swing app that recently stopped working well, there were some problems in our MySQL database with some table locking and some memory leaks which i have indentified and fixed.. I thought it was the database performance that was the problem but now that all that is fixed it more appears that out of nowhere it is taking a long time to even acquire a connection to the db from the app. The connection pooling we wrote is shared across projects and all other projects are working fine tho. I am not sure where to start to debug and solve this prob... Any suggestions?
I use Netbeans and used the profiler to track down my memory leaks.. To make matters worse it does not happen on my local development
unit, only on the server which is under load but i can run massive queries in Toad on millions of records in a split second...
Confused
GB