Lester

It is the exact opposite of what we expected too!

I should state up front that I did not setup this machine and the person that did has left. However, I do know that the system is running Firebird Classic 2.1 and that we are connecting from a Delphi client running on Windows 7.

Looking at the Linux machine if I run blkid I get the following:


/dev/cciss/c0d0p1: UUID="53d1653c-eb39-4f38-8291-942cd918694f" TYPE="xfs"
/dev/cciss/c0d0p5: UUID="61c6f303-0576-4bbc-8f56-164968ac9684" TYPE="swap"
/dev/sda1: LABEL="HP v210w" UUID="D06E29286E2908B4" TYPE="ntfs"

This implies that the majority of the disk is formatted as ntfs. I believe that this is because the machine is also used as samba mounts for Windows, but I could be wrong on this point.

Does any of the above provide any pointers?

Thanks

Neil

--- In firebird-support@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> grip_2ls wrote:
> > We have a client running Firebird on a dedicated multi-core Ubuntu server. For some reason the performance is awful compared to the Windows test server that we have. Queries are taking a few seconds on the windows machine are taking one and a half minutes on the Linux machine. Even a gbak is taking 3 hours on Linux compared to 45 minutes for the equivalent sized database on windows.
> >
> > I am looking for someone that is UK based that could do some paid consultancy to look at the issues and help us find a resolution.
> >
> > Does anyone have someone that they would recommend?
>
> I have to say that is the exact opposite of what I am finding on machines. Even
> where same machine is dual booted, windows is substantially slower than an SUSE
> linux setup.
>
> First question would have to be what 'setup' are you using on the linux box ...
> I still prefer classic but then it's running into PHP as the access layer. And
> what file system have you installed ... I believe that does have a strong
> bearing on performance.
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>