This content has been marked as final.
Show 2 replies
-
1. Re: Declared sql runs slowly
treespace Jun 13, 2004 12:18 PM (in response to veranda)To confirm the performance loss, I would execute the same query using the same driver using JUnit or from a simple Java main method. Unlikely to be a JBoss problem per se. PL/SQL will be faster, but no an order of magnitude faster.
-
2. Re: Declared sql runs slowly
gorano Jun 14, 2004 7:33 PM (in response to veranda)What is the total query time in the 2 examples given?
You will have an overhead from java compared to
plsql before the actual query is processed on the DB and after the query is finished and the result is transfered back to your application. For very small queries you could end up with this result. If the query is more heavy you shouldn't notice the difference.
/G