On a usual basis "stored procedures" are faster. The advantage is that they scale well.
If you have 1. high peak usage of the application, and 2. differing result sets returned in the ref cursor stick to stored procedures. Actually truth be told, you need to write the usage scenarios and determine the bell curve of the result set before you decide which one will be better off. Hope this dense stuff helps. :-) Cheers Rajesh Thiharie Aithent, New Delhi, India 91 124 6455511 x 314 Work Kesavanarayanan, Ramesh (Cognizant) wrote:
i have a query based on Stored procs. I also have this implementation based on CachedRowSet. I just want to know which one of them will be faster.
=========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
