Hi !

rudi_josic wrote:

> Hi Alexandre.
>
>
> > 3.) The execution plan on both are the same ?
>
> yes, the test was maded over same statements
>
>
>

Same statements not necessary produce the same execution plan... look
closely ate the generated plan on both servers.

> > 4.) Same architecture on both ? (CS or SS)
>
> on linux server try both ss and cs with the same results, windows
> server run ss.
>

The firebird configuration was the same ?

> > 5.) What is running o debian, any chance you have X started ? (it
> will consume a lot of memory)
>
> no, base and fresh installation, no graphical interface and no other
> app or services.
>
> > 6.) If you run your queries locally the perforance is bad too ?
>
> yes, slow locally too.
>

but did you did a local tcp/ip connection (using localhost or 127.0.0.1)
or local connection in the sense of no network protocol being in the game

examples:
connect localhost:my_database user sysdba password masterkey

is a local connection using the TCP/IP loopback interface

connect /home/database/my_database.fdb user sysdba password masterkey

does not use any network protocol...

The other things you could have a look is overall file system
performance (for example: do a copy of a big file in both windows and
linux and measure the time)

Test HD's performance with hdparm -Tt (on linux) and look if the numbers
looks good. Look at some HD's options DMA mode for example, it gives a
huge performance bennefit if turned on.

Do you have a spare computer to try another instalation of debian ?

hth

see you !

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