rudi_josic wrote:

> Hi all and excuse my english.
>
> I want to change my DB (firebird) server (windows to linux), but there
> are many different linux distributions. I would like to know what
> linux distribution you recommend to install a firebird BD server.
>
> I tried debian (etch) but, i got bad performance (windows was 20 times
> faster) both servers : PIII 1Ghz, 512MB RAM, 250GB HD, 10/100 ETH,
> Firebird 1.5.3, on the same network.
>
> Debian server was 2 days since install and just running firebird for
> the test; and windows server about 2 years running and have 3 firebird
> 1.5 DB working (serving about 35 connected clients during the test)
>
> i've always heard about high performance of firebird server over
> linux, maybe a did something wrong installing my linux server. or, are
> there some config ticks to speed up firebird over linux? or, i choose
> the wrong distribution of linux to instal a firebird server.
>
> Any suggestions will be appreciated.
>
> Thanks in advance.
>

Few questions...

1.) Same Firebird version on both ?
2.) Freshly restored database on both ?
3.) The execution plan on both are the same ?
4.) Same architecture on both ? (CS or SS)
5.) What is running o debian, any chance you have X started ? (it will
consume a lot of memory)
6.) If you run your queries locally the perforance is bad too ? (this
will put a part any network problem, name resolution and the like)

That's enough for now... Let's wait for your responses and try to help..

There is no best distribution... if you ask 3 different guys that uses 3
distinct distributions each one you tell you to use the one he
chooses... I always use redhat family (Conectiva, RedHat, Fedora), but
that is just because I started with Conectiva, If I had started with
slackware probably I would stick to it or Debian, or any other distro...

see you !

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