Hi Helen,
thanks for replying..
My situation..
does firebird saves execution plan both for Sp and dynamic SQL's..is
there a performance difference?

What I meant was.. SQL server 2000...saves execution plan of stored
procedures as well as Dynamic SQL.. what does Firebird do? We r
developing an application which uses client(smart in .net) and
server in .net, and Firebird as database.I would like to go for
Dynamic SQL(using LLBgen like product)..as I feel maintaning stored
procedures is a painful job..


--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 07:40 PM 13/07/2005 +0530, you wrote:
> >Hi,
> >
> >I would like to know if there is a huge difference between using

SP or

> >Dynamic SQL.I am in process of deciding an architecture where

clients

> >will be .net smart client,and firebird1.5..I have about 120-130
> >tables..Clients,will be of POS terminal type..connected to a

central

> >server..
>
> Yes, like there's a huge difference between peeling an apple and

making an

> apple pie. They are different eating experiences. If you have an

operation

> that is achieved by a simple insert, update or delete statement,

it doesn't

> make sense to push that work into a stored procedure. If you have

a

> complex operation that imvolves updating multiple tables or (in

the case of

> selects) needs a set that couldn't be got easily with a single

DSQL

> statement, then you want a stored procedure.
>
> If you only want to eat the apple, don't make the pastry and bake

the pie.

>
> ./heLen