Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Which is faster, Insert(.... or Procedure(... that does Inserts?
Thanks to all in advance.
The question involves calls from a C++ program using Microsoft's ADO.
If you execute a command using ado that is a string like:
"insert into TableA ( filed_1 , field_2 ) values( 1 , 2 );"
Then execute a stored procedure like "call Procedure_A( 1 , 2 ) and
let the
stored procedure do the inserting like:
psudo-code - Procedure_A( 1 , 2 ) {
insert into TableA ( filed_1 , field_2 ) values( 1 , 2 );" }
Which one is actually faster. Is the procedure faster because the access path is precompiled in?
Best,
Ken Sproule
kenmn_at_tds.net
Ken Sproule
kenmn_at_tds.net
Received on Thu Mar 16 2000 - 14:21:28 CST