hey guys,
i have data source named 'dbconnection' for an Application. this Application has many transaction. and it was really slow(30 sec to be up) but after some changes it took 8 sec.(At End of this Post)
My Questions :
1-for the first time it is fast(just 8 sec) but in 2nd and 3rd and .... it goes slow like before(30 sec).when i refresh the application, same thing goes.
2-iwhy i can't change the Transaction to 'LLR' for better performance
2-what's the difference between minimal and initial capacity?
3-why i can't make the 'wrap Data Types' unchecked ?after applying nothing happens.it's again checked!
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
high active connection is : 9 and i set the parameter like this
-----
initial & maximum & minimum capacity : 10
statement cache : 0 (because it's the statements in application is changing every tie and it has few hit in long-time running)
Test Connections on Reserve : Checked
Second to trust : 5
shrink frequency : 300
pinned to thread : Checked