> 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??

IBO is doing some extra things that are designed to cache schema data and
such so initial connection and prepare will take longer. Continue to do
more things and you should notice IBO will hang in there fine.

Jason Wharton