Hi all,
decided to find out who is the fastest when working with DB using jdbc. I
wrote a simple servlet that does the following:
1) acquires connection from the App. Server's JNDI tree and selects 7000 records from
an Oracle table.
2) acquires connection using DriverManager (OracleDriver) and selects 7000 records
from the same table.
The results are
1) WL ~4000 ms vs. Orion ~7000 ms
2) WL ~4000 ms vs. Orion ~6600 ms
I agree that WL outperforms Orion because it is using its own DB Driver. But why even
standard OracleDriver on Orion is working ~3 sec slower than on Weblogic 6.1?
May be it is possible to tune Orion so that it could outperform WL when using jdbc?
Egor Savotchkin
try {
System.out.println("********************************************************
*");
System.out.println("Init ctx ... ");
start();
Context ctx = new InitialContext();
end();
System.out.println("Getting DS ...");
start();
DataSource ds = (DataSource) ctx.lookup(JNDI_NAME);
end();
System.out.println("getting connection ...");
start();
Connection conn = ds.getConnection();
end();
System.out.println("Connection : " + conn.getClass());
System.out.println("creating statement ...");
start();
Statement st = conn.createStatement();
end();
String query = "SELECT * from logs";
DatabaseMetaData dbmd = conn.getMetaData();
System.out.println("executing : " + query);
start();
ResultSet rs = st.executeQuery(query);
end();
System.out.println("ResultSet : " + rs.getClass());
int i = 0;
System.out.println("rs");
start();
while (rs.next()) {
i++;
}
end();
rs.close();
st.close();
conn.close();
conn = null;
System.out.println("i = " + i);
System.out.println("--------------------------------");
System.out.println("getting connection ...");
start();
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"url", "xxx", "xxx");
end();
System.out.println("Connection : " + conn.getClass());
System.out.println("creating statement ...");
start();
st = conn.createStatement();
end();
System.out.println("executing query : " + query);
start();
rs = st.executeQuery(query);
end();
System.out.println("ResultSet : " + rs.getClass());
i = 0;
System.out.println("rs");
start();
while (rs.next()) {
i++;
}
end();
} catch (Exception ex) {
System.out.println("Exception : " + ex);
}
