Java within Oracle is faster than JDBC from outside but not much. Fastest is to use pure
SQL, second best ist PLSQL, Java is always slower than the other two. YMMV!
Regards
Felix
BTW: No matter whether Java or PLSQL - bind variables are the key to performance.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4042620#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...