--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

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

Hi Alexandre.

thanks for reply

> 1.) Same Firebird version on both ?

yes, firebird 1.5.3.

> 2.) Freshly restored database on both ?

just for linux server, the windows server is the producction server
and is running 24x7, the last Maintenance (back-up/restore) was about
a three months ago.

> 3.) The execution plan on both are the same ?

yes, the test was maded over same statements

> 4.) Same architecture on both ? (CS or SS)

on linux server try both ss and cs with the same results, windows
server run ss.

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


hope it help and thanks again.