thanks daniel..

for our project..i want to go for dynamic sql ..using a product like
llbgen..i feel stored procedures are a pain and difficult to maintain
especially if database design changes a lot..and i dont think getting
database desin right first time ever happens..yur take on this?
regards
vishal

--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...>
wrote:

> Hi,
>
> At July 14, 2005, 02:47, women_lover_best wrote:
>
> > thanks for replying..
> > My situation..
> > does firebird saves execution plan both for Sp and dynamic

SQL's..is

> > there a performance difference?
>
> Firebird does save(cache) the execution plan of a prepared DML for

the

> duration of the connection(not just the transaction), unless you
> explicitly unprepare the DML statement. And that cached execution

plan

> is only available within that connection only.
>
> This was reply on top of what I said in the Firebird Architect

group.

>
> --
> Best regards,
> Daniel Rail
> Senior Software Developer
> ACCRA Consultants Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)