I recently encountered by activating setShowSql(true) shows me many mysql queries repeadly several times(mostly 3 times) while testing on development mode where i have just one user session.And that is the main cause of my website slowdown during high traffic and by monitoring my website on new relic monitoring system, it shows me always DataSource.getConnection holding so much time.
Please go to this post which has full details along with screenshots.
http://stackoverflow.com/questions/3780 ... h-probablyMany thanks in advance..
Tim