It's been about 2 years since I took the ORACLE systems adim course but
I can clear recall that with each "embedded" sql statement called from
a program must be "COMPLIED" and syntax check, "pre-processing", before
execution. As an example, if you send "select * from users" and "Select
* from
users" , each one of theses statement must be compiled then executed,
even
for the change of select to Select.
Also, if you used "embedded" sql how do you use things like primary keys
i.e. UserId
during new inserts with out jumping thur hoops with multi-selects?
Gaurav Kishore wrote:
>
> This is what I like most about newsgroups. Yesterday, I fired a half-baked, unclear
> question about the performace of SP's in servlets. Not only my question became more
> solid and specific, but it also started a chain of mails. And the end result is
> that my knowledge was enhanced by developers who are well experienced in their
> respective fields and who gave invaulable information (which I am sure I won't find
> in any book), which comes out of experience only.
>
> I want to specially thank Jon, Joe Sam Shirah, Craig McClanahan. (and everybody
> else whose name I might have missed to mention, by chance)
>
> Thanks
> Gaurav
--
James K. Tuan Ph: 203.961.1686
PetroChemNet Inc. Fax:203.357.7011
1281 Main Street email: [EMAIL PROTECTED]
Stamford CT 06902 URL: www.petrochem.net
___________________________________________________________________________
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
