Subject Re: [firebird-support] Is ESQL Faster than Dynamic SQL.
Author Alexandre Benson Smith
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil