> Could you run another test. Using ISQL, collect the statistics for the
> query. Run it twice and send us the results.
> ISQL> set stats;
> In general, InterBase does use a cache when it is available.

Hello,

I send more informations.
I mean that I make something wrong,
because I got very small difference in performance with 100 and 8000
buffers.

As I wrote last time, the Informix on the same hardware has really big
difference between queries (25s and 1s).

Values before parenthesis are for 8000 buffers, in parentheses for 100
buffers.

Server:
LI-T1.0.0.368 Firebird Beta2
192MB RAM, Linux RedHat 7.0

Database:
Page size 4096
Page buffers 8000 (100)

First connection after reboot (with empty filesystem cache)

select sum(price) from inv_rows, inv_heads, companies
where inv_rows.invcode=inv_heads.invcode and
inv_heads.compid=companies.compid and
companies.compname like 'A%'

Current memory = 34841600 (797696)
Delta memory = 245760 (245760)
Max memory = 34918488 (874584)
Elapsed time= 33.18 (33.82) sec
Cpu = 0.00 sec
Buffers = 8000 (100)
Reads = 7053 (20998)
Writes = 0
Fetches = 1100224

[The same statement as above]

Current memory = 34841600 (797696)
Delta memory = 0
Max memory = 34918488 (874584)
Elapsed time= 16.68 (18.11) sec
Cpu = 0.00 sec
Buffers = 8000 (100)
Reads = 0 (20916)
Writes = 0
Fetches = 1099269

Quit isql

Next connection, again isql (to determine filesystem factor)

[The same statement as above]

Current memory = 34841600 (797696)
Delta memory = 245760 (245760)
Max memory = 34918488 (874584)
Elapsed time= 17.28 (17.90) sec
Cpu = 0.00 sec
Buffers = 8000 (100)
Reads = 7053 (20998)
Writes = 0
Fetches = 1100224

[The same statement as above]

Current memory = 34841600 (797696)
Delta memory = 0
Max memory = 34918488 (874584)
Elapsed time= 16.80 (18.22) sec
Cpu = 0.00 sec
Buffers = 8000 (100)
Reads = 0 (20916)
Writes = 0
Fetches = 1099269

Quit isql

As I wrote, I need to know if difference times are normal, because for
example, IB uses something by other way than Informix.

Thank you very much.
Leos