Subject | Re: [firebird-support] Re: Performance |
---|---|
Author | Ivan Prenosil |
Post date | 2007-04-29T19:20:56Z |
> I've done some further tests. I've tried FB1.5.4. It doesn't haveAlways make tests with the simplest possible client, i.e. ISQL.
> 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.
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/