Hi,
I have a difference of 25%... 2.9msec fb1.5 and 2.3msec ib7... I see that
the first query time is identical on both DB, so I'm near sure that ib7
manage better the cache!

A select of this kind:
'SELECT * FROM MAIN WHERE UOMO=1 AND PROVINCIA=9 AND LOCALITA=5 OR AMICI=1
OR NATURA=1 AND PUB=1 AND CINEMA=1 OR MARE=0 ORDER BY ID DESC';

65 fields, some varchar, a large part integer, 60 indexes, 1 index
descendant on ID

Launching this query serially 100 times.... with the result as above.

The file db is the same, builded with IB6. It has 550,000 records and 733MB
of size.

Hw Athlon 1700Mhz, 266ddr, and a simple ide 7200 HD ibm.

The db is without forced writes, with 4kb pages, with 8192 cache (for a
total of 32,768Kb cache).

> Were the IB/7 patches applied?

IB7 patches? I just downloaded the trial and installed it from borland,
that's all.

The db is just restored from a backup that has previously executed garbage
collection.

Bye.

> Were both databases newly restored, and did you run the test cases

multiple

> times?
>
>
> Regards,
> Aage J.