Embedded SQL vs Stored Procedures

From: Gama Franco <gama_franco_at_clix.pt>
Date: Tue, 07 Sep 2004 17:10:29 +0100
Message-ID: <chkm5u$2lla$2_at_pegasus.fccn.pt>


I'm using OCCI to develop a new aplication, but I have one doubt about the most efficient way to make an operation. The operation makes inserts some rows in different tables, and also creates some new tables. I would like to know if it is faster to compute this kind of operations if they are hard codded in OCCI, or using a stored procedure that recieves all the parameters needed and takes care of the insertions and creations.

Best regards,
Gama Franco Received on Tue Sep 07 2004 - 18:10:29 CEST

Original text of this message