> >The following procedure tasks 11 seconds to run: inserting
> about 90,000
> rows
> >per second.
>
> >Is this to be expected?
>
> You're pretty good !
>
> I'm doing 19230 per sec on a Xeon 2.2Mhz HDD SCSI 10000rpm
> RAID5 2Gb RAM +
> W2K.
>
> What's your hardware ?
>
> --
> Jerome

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

0.031u 0.000s 0:11.75 0.2% 132+254k 0+0io 0pf+0w