Then, you don't have the implementations, right? SPs and CachedRowSets aren't mutually exclusive AFAIK in this case. You can use both. Both have advantages and drawbacks. If the SP is coded properly(optimized to fit your app the best) and the CachedRowSet implementation uses a policy that suits your application's behavior, then using BOTH of them will be the most efficient.
Advantage of using SPs is performance in the execution of a query and an extra level of complexity in it, For CachedRowSets, less round trips to the database. Drawbacks of SP are: partition of business logic, lack of portability. Drawbacks of CachedRowSets: wrong policy for your app's behavior can make overhead offset performance gains(worse performance). Small sets can have the same impact. Memory requirements for CachedRowSets are bigger than a simple ResultSet. HTH, Juan Pablo Lorandi Chief Software Architect Code Foundry Ltd. [EMAIL PROTECTED] Barberstown, Straffan, Co. Kildare, Ireland. Tel: +353-1-6012050 Fax: +353-1-6012051 Mobile: +353-86-2157900 www.codefoundry.com > -----Original Message----- > From: Kesavanarayanan, Ramesh (Cognizant) > [mailto:KRamesh@;chn.cognizant.com] > Sent: Monday, October 28, 2002 1:11 PM > To: 'Juan Pablo Lorandi' > Subject: RE: stored procs and CachedRowSet > > > but my problem is which is very efficient ? Can you explain > the scenarios where in i would go for SP and that of CachedRowSet. > > > > Regards > > Ramesh Kesavanarayanan > [EMAIL PROTECTED] > +91-44- 811 3063 ext 2252 VNet- 42252 > > > > -----Original Message----- > From: Juan Pablo Lorandi [mailto:rifle@;CODEFOUNDRY.COM] > Sent: Friday, October 25, 2002 9:39 PM > To: [EMAIL PROTECTED] > Subject: Re: stored procs and CachedRowSet > > > Why don't you code a test suite that runs them, and measures > time spent? Then a second test suite that, using threads > executes those concurrently and measure how many runs you can > achieve in a certain amount of time, etc. > > > > Juan Pablo Lorandi > Chief Software Architect > Code Foundry Ltd. > [EMAIL PROTECTED] > > Barberstown, Straffan, Co. Kildare, Ireland. > Tel: +353-1-6012050 Fax: +353-1-6012051 > Mobile: +353-86-2157900 > www.codefoundry.com > > > > -----Original Message----- > > From: A mailing list for Enterprise JavaBeans development > > [mailto:EJB-INTEREST@;JAVA.SUN.COM] On Behalf Of Kesavanarayanan, > > Ramesh (Cognizant) > > Sent: Friday, October 25, 2002 11:02 AM > > To: [EMAIL PROTECTED] > > Subject: stored procs and CachedRowSet > > > > > > Hi all, > > > > 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. > > > > > > Regards > > > > Ramesh Kesavanarayanan > > [EMAIL PROTECTED] > > > > > > > > ============================================================== > ============= > To unsubscribe, send email to [EMAIL PROTECTED] and > include in the body of the message "signoff EJB-INTEREST". > For general help, send email to [EMAIL PROTECTED] and > include in the body of the message "help". > =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
