It depends on the database + the nature of the queries. In many (most?)
databases, stored procedures are pre-compiled, which means that they are
faster than interactive SQL. However, the difference is dwarfed by the
execution time of a query that big.
/Manne
-----Original Message-----
From: Robuschi (Delfi) [mailto:[EMAIL PROTECTED]]
Sent: 12 October 2000 14:35
To: [EMAIL PROTECTED]
Subject: Re: Stored Procedures
I'm just tryin the best solution between simple queries and Stored
Procedures.
So i placed 5 tables, integrally referenced each other, and the main table
has 100.000 records.
I tried a query that joins these tables and a stored procedure that does the
same thing.
The result was the same: 4 seconds to execute both the query and the stored
procedure. So we decided to use queries... there are less troubles in
deploying the application.
Hope this can help you...
Robuschi Roberto -------------------- Delfi srl
P.za Ravenet 1/b - 43100 PARMA
Tel. 0521/932411 Fax 0521/989045
[EMAIL PROTECTED] --- http://www.delfi.it
===========================================================================
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
===========================================================================
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
