Hi Nigel,

> P4 2.8GHz HT(not turned on), 512MB DDR400, single IDE disk, Asus P4R800
> mobo, FreeBSD4.8
>
> Actual command and output:
>
> sgi-o2:~/code> time isql -u sysdba -p masterkey < bench.sql
> Use CONNECT or CREATE DATABASE to specify a database
> Database: "localhost:/u1/db/fill.fdb", User: sysdba
> Use CONNECT or CREATE DATABASE to specify a database
>
> INT_LOOP DTM_TIME
> ============ =============
>
> 0 17:31:00.0000
> 1000000 17:31:11.0000
>
> Current memory = 2607132
> Delta memory = 957460
> Max memory = 2607132
> Elapsed time= 11.55 sec
> Cpu = 0.00 sec
> Buffers = 75
> Reads = 37
> Writes = 31512
> Fetches = 8043920
>

Actually, running your exact test, I'm doing slighty better :

INT_LOOP DTM_TIME
============ =============

0 01:11:53.0000
1000000 01:12:11.0000

Current memory = 2744684
Delta memory = 1029956
Max memory = 2744724
Elapsed time= 18.78 sec
Buffers = 2048
Reads = 0
Writes 29648
Fetches = 8043918

=> 53250 /s

Which is still behind what you get.
I wonder if it's the kind of improvement I should expect from running FB
under Linux...

Cheers.

--
Jerome