"Karau, Joe" wrote:
>
> Stored procedures will be more efficient then using JDBC and directly
> running queries. However, the difference may not be noticed unless a large
> and complex query was performed. The reason that stored procedures are more
> efficient, is that they are stored in the database as optimized queries.
> Therefore, they do not need to go through the SQL optimizer, and often no
> longer need to go through the SQL parser.
The biggest problem with stored procedures however is portablilty. Using
stored procedures, you have to redo all your sp's when you deploy on
another database. It may be more efficient, but i prefer the
portability. Besides, many rdbms cache the optimizations for queries and
thus the difference may not be noticable anymore.
sven
--
======================================================================================
Sven E. van 't Veer
http://www.cachoeiro.net
Java Developer [EMAIL PROTECTED]
======================================================================================
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
