Embedded SQL vs Stored Procedures

From: Gama Franco <gama_franco_at_clix.pt>
Date: Tue, 07 Sep 2004 09:24:36 +0100
Message-ID: <chjqsf$2dov$1@pegasus.fccn.pt>

Hi,

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 - 03:24:36 CDT