Got any example on how you'd do it using a stored procedure? Plus could you elaborate on why the performance would be higher using a stored procedure rather than a direct paging technique from java ?
-----Original Message----- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 11:05 AM To: Struts Users Mailing List Subject: Re: Queries and Paging If you are looking for high-performance, use a stored procedure. There are other techniques, but I'd bet lunch that none will come close in terms of performance. Larry On Mon, 28 Feb 2005 09:54:04 -0600, CRANFORD, CHRIS <[EMAIL PROTECTED]> wrote: > How have others implemented database queries and paging techniques in > your struts applications? I'd like to see how others have implemented > such functionality to see if I can improve upon our current framework. > > _______________________________________________________ > Chris Cranford > Programmer/Developer > SETECH Inc. & Companies > 6302 Fairview Rd, Suite 201, Charlotte, NC 28210 > Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042 > Email: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]