Stored procedures are likely to be faster (I don't know since I've never
actually used them)since they are native calls instead of SQL. From a
compatibility point of view the problem is, from what I understand, that
they are very much tied to a particular database implementation. There isn't
a standard stored procedure syntax that everyone uses like SQL.
I'm sorry I can't be more helpful on this but we've kind of reached the
limit of my knowledge on this topic.
-----Original Message-----
From: ryoung [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 1:12 PM
To: [EMAIL PROTECTED]
Subject: Re: OFFTOPIC "Standard SQL" -- WAS: "RE: jsp and NT"
<snip>
Third, don't use stored procedures. Only access the database
through JDBC
statements.
since i've inherited a system where i may only be allowed access
[SqlServer7] through stored procedures [negotiations still going on with the
vendor/partner], is this a performance observation, or an error
observation??
thanx,
robert young
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
