Hi guys,
I was wondering if anyone knows what is the best parameter to deal with the connection testing using C3P0.
I'm curently using the automaticTestTable parameter which works fine, but I was looking forward to speed up my application. I took a look at the documentation and here is what is said :
Quote:
The most convenient way to speed up Connection testing is to define the parameter automaticTestTable. Using the name you provide, c3p0 will create an empty table, and make a simple query against it to test the database. Alternatively, if your database schema is fixed prior to your application's use of the database, you can simply define a test query with the preferredTestQueryparameter.
So, I tried the preferredTestQuery parameter and it works fine too. I'm just unable to say which one has the best performance and under which circumstances. I'm having trouble to find any information about it since, when you type those two words, you get description of configuration from people having troubles...
Any information will be apreciated,
Thanks in advance.
Login
FAQ
Search