Subject Re: [firebird-support] About firebird performance
Author Hector Sánchez
Thanks for your reply Ann...please see below your comments:

> Very odd. Could you collect the performance stats for the query on the two systems? >Specifically, I'd like to know how much physical I/O each did - that's reported as Reads >and Writes. Fetches and Marks don't matter here.

This is what I did:

# /opt/firebird/bin/gfix -buffers 100000 -user SYSDBA -password
XXXXXX /sis/arodat/test.fdb
# /etc/ini.d/firebird restart

1) select count(*) from TABLE1 with pagebuffers=100000 on the database:
execution time=51min

# /opt/firebird/bin/gfix -buffers 0 -user SYSDBA -password XXXXXX
# /etc/ini.d/firebird restart

2) select count(*) from TABLE1 with pagebuffers=0 on the database:
execution time=1sec

Now I'm getting mad...second execution took only 1 sec...this is
certainly due to cache use but if I restarted firebird server process,
does it keep cache?

Planatec Software S.L. ** <>
telf: +34 964 340 560 ** fax: +34 961 130 921