Hi, Stored procedures are database specific. if you write a stored procedure in sql*server, it will not execute in postgresql. Updating or changing the logic is time consuming if you have the logic distributed in the server and in client. you might want to cosider the following before using them
- Is the logic very simple, ex only 2 queries with no complicated loops etc - is performance very critical - will you be using only one database or you might have to port your stuff to another database? hth Nagarajan. On Friday 25 October 2002 12:50, you wrote: > 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 =========================================================================== 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
