Subject Re: [firebird-support] Re: Performance
Author Ivan Prenosil
> I've done some further tests. I've tried FB1.5.4. It doesn't have
> this problem. In FB2.0.1, IBOConsole statistics shows that the query
> execution time is 0.0074 seconds but it is in fact much longer than
> that. To double check, I will do some test using the ODBC driver to
> access FB.

Always make tests with the simplest possible client, i.e. ISQL.
Use SET STAT ON; to see whether extra disk activity will be visible there.
How big is the cache the database uses ?
Did you validate the database using GFIX ?

Ivan
http://www.volny.cz/iprenosil/interbase/