Thanks
Then how to handle security issues regarding the query and result set, beacuse
they are embedded in the java code?
TIA
Gaurav
jon * wrote:
> > Thanks.
> > Even if I have to use very large SQL statements, is it not worthwhile
> > (performance wise) to use SP's ??
> > What's the reason??
>
> The answer that I found was that performance wise even for large SQL
> statements it was not worthwhile to use SP's. Why? I don't know...Oracle
> isn't open source so I can't look at their code. ;-)
>
> Both Village and Town are extremely fast and on the back end, they just
> create prepared statements so it really does not matter how much SQL code
> you have...it generates it all for you transparently and quickly.
>
> -jon
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
