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)