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]

Reply via email to