Subject | ISQL Faster than IBO?.. why? |
---|---|
Author | Carlos GarcĂa Trujillo |
Post date | 2006-10-20T03:50:07Z |
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
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