Subject Is ESQL Faster than Dynamic SQL.
Author inoffensive_2006
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?