Jerome Bouvattier wrote:

>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,

Since linux versions has forced writes off and Windows version forced
writes on by default, I think if you run on linux you will get a better
performance...

See you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br