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
