I did what you suggested, it works perfectly now..

Gordon Hamm
Voice Data Systems Inc.

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, July 19, 2001 12:16 AM
Subject: Re: [IBO] Params


> 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/
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>