| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Using procedures instead of coding update/insert
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: GuptaR_at_telecomsys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Wed Jan 16 2002 - 14:43:55 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |