Ann W. Harrison wrote:

> ...
>
>>...
>>
>>I've run benchmark on the same database but on different servers.
>>
>>Computer1:
>>2CPUs PIV HT2.4 512Mb RAM, SCSI drives
>>Gentoo Linux 2.4
>>
>>Computer2:
>>2CPUs PIV HT3.2 4GB RAM, SCSI drives
>>Fedora Core 1 Linux 2.4 (with NPTL)
>>
>>Oddly the first computer performed task in 3 minutes while it took 30
>>minutes to accomplish jobs for 2nd server.
>>
>>
>
>Hunh. 10 to 1 is really odd. What's HT? Sorry to be an ignoramus.
>Interesting that the fast computer has 1/8 the memory of the slow
>computer. What happens if they both run the same version of Linux?
>
>

HT = Hyper-threading
If think my eyes or yours are playing with us :-) Computer 2 (the fatest
one) has 4GB while Computer 1 (the slowest) has 512MB

I think one thing should be considered is if the OS are caching the
database in the same fashion on both computers.

Another thing, I have read that Gentoo performs better than other
distros since everything is compiled using the best performance settings
for the installed hardware. But a 10 times diference is too much for me :-)

>
>>In a few days I'm going to install other release of Fedora on second
>>computer to test whether Linux distribution has any impact on firebird
>>performance. I'll send a post to inform you with the results.
>>
>>

What about Gentoo on the second server ?

>
>>... it would be nice if one could find documents
>>related to tuning firebird parameters.
>>
>>
>
>A significant project goal is to minimize the number of tuning
>parameters by thinking about the problems they're meant to address and
>designing the system to handle those problems rather than dropping them
>on the unfortunate dba. And we should increase the default lock table
>size and the default hash table width - those were designed for
>computers of the 1980's, where every byte of memory counted. Sigh.
>
>

And besides what could be improved I think FB does a really good job on
this point.

>Regards,
>
>
>Ann
>
>

see you !

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