Ok, I implemented prepared statement caching for our JCA connector. I
see the same 30% improvement I spoke about below. The is with Oracle
9.2 mind you. I did the same test with HSQL and it really ahd no affect.
Bill
Bill Burke wrote:
Hey,
Seems statement caching does make a difference,
Hey,
Seems statement caching does make a difference, about 30% difference. I
was always under the assumption that it didn't and finally tested it out
for myself under Oracle 9.2. Here's the test:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;