Hi Rudy,

Can you do another test please ?
Run the same querry against both installations from isql : there are
different performance results on the same data amount ?

Thank you,
Doru

--- In firebird-support@yahoogroups.com, "rudi_josic" <rudijosic@...>
wrote:

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