That was me who made that statement about prepared statements being faster than stored procedures. It was not a general statement.. As my e-mail states, we have done some testing. Our test included inserts into more than 10 different tables on different system configurations (Sparc solaris-E-4500 oracle8i, oracle8i on linux and 8i on NT). We did use bind variables for both stored procedures and prepared statements but found prepared statements to be faster for inserts and deletes. The only thing we did not use was bulk binding and that we can not use based on our project requirements.
Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
