> Question regarding preparing queries inside stored procedures, inspired by: "Re: Query is running slowly for the first time."
>
> In that post, Thomas( I think ?) reckoned the slow down on large tables, is form the query becoming unprepared.
>
> I have a selectable stored procedure, that call another selectable stored procedure, ie. Very basically:
>
> For
> Select this_field, that_field
> from my_table
> into OField1, OField2
> do
> begin
> select another_field
> from my_sub_proc(:Ofield1)
> into OField3;
> end
>
> I am experiencing this same slow down, so I take it, that means that my_sub_proc is getting re-prepared for every iteration of my_table?

I don't think this happens. It might be different if you execute a
dynamically built SQL via EXECUTE STATEMENT though.

Firebird core devs might jump in here with their knowledge about the
internals.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/