Subject ISQL Faster than IBO?.. why?
Author Carlos GarcĂ­a Trujillo
I'm working over a SLOW connection with a Firebird 1.5.3 Superserver
and i've observed this severe diference in performance:

when i connect to the database using ISQL and run a very simple query
like this:

SELECT COUNT(*) FROM RDB$RELATIONS;

the results are showed almost INSTANTANEOUSLY!!,

But when i connect to the database using IB_SQL (or my own
application made with IBO) the same query takes more than 5 seconds,
even just preparing the query takes may take 3 or 4 seconds...

Why is this drastic difference?? What must i do to can have this kind
of speed in my application???... as i can see both applications, mine
and ISQL are just connected to the server, in my application (and
IB_SQL i supose) a IB_Cursor is used, so the speed should be the
faster possible over IBO... right??

Thanx in advance