inoffensive_2006 wrote:

> Hi Folks:
>
> I'm sure this has been addressed before, but Yahoo's search
> has been responding with:
>
> Search server is busy (code=300). Please try again later.
>
> for the last day.
>
> I've been using dynamic SQL to build my SQL in C++ strings
> and passing them to Firebird through IBPP's facilities. This
> has been working well, but I'm looking to speed up performance.
> In particular, we want to speed up SELECTS.
>
> My partner and friend in this project tells me that using
> static SQL will improve performance of the SELECTS.
>
> I use IBPP's Prepare() and Execute(). Then I call Fetch()
> for each record.
>
> Would replacing this dynamic SQL with ESQL provide a
> performance advantage?
>
> Thanks
> Larry
>

Well... I am not answering your question directly.

But I would advice you to prepare once and execute many times.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br