Re: Embedded SQL vs Stored Procedures

From: Gama Franco <gama_franco_at_clix.pt>
Date: Tue, 07 Sep 2004 17:08:24 +0100
Message-ID: <chkm21$2lla$1@pegasus.fccn.pt>

Jim Kennedy wrote:

> "Gama Franco" <gama_franco_at_clix.pt> wrote in message
> news:chka4k$2i4h$1_at_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

> 
> Don't create new tables.  It is very unlikely that you really need to do
> this.
> Jim
> 
> 

Hi,

Unfortunatelly I really have to. But I would like o know if someone faced the problem of effiency in Embedded SQL vs Stored Procedures.

Best regards,

   Gama Franco Received on Tue Sep 07 2004 - 11:08:24 CDT