Yes, it most certainly is. Especially if they are ran frequently. I don't
think it is that expensive to have allocated statement handles on the
server. Constantly recompiling (preparing) statements is expensive for the
server. With the super-server architecture of recent versions of interbase
statement prepares are cached and if I'm not mistaken statements that are
alike are stored as one and reference counted. If not, then that ought to be
one of the first things Firebird developers do.

If they are not ran frequently then using executeimmediate is a good way to
go if you are not selecting records or concerned about the RowsAffected.
Either that or you can do a timeout every now and then to unprepare them.

Hope this helps.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Gordon Hamm" <vds@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, July 18, 2001 8:42 PM
Subject: Re: [IBO] Params


> > You are better off dong the extra stuff in a dedicated query and then
> > refreshing the original ones.
>
> I thought about this, but I have about 10 different types of queries. Is
> that ok to do ??
>
>
> Gordon
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>