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 - 00:00:00 CST