I have below mentioned configuration for connection pooling on
tomcat server 6.0.20:-
Issue here is, that as day passes by, same query that takes about 12-14 seconds to execute in morning takes about 50-70 seconds later in the day...after say 2-3 hours..
And performance degrades further on..I am sure, something is wrong in my connection pooling configuration in server.xml file.
I am not using hibernate or other ORM frameworks.
Pl let me know how do I optimize this configuration.