Re: Why IDS-Linux is so slow?
>now I'm looking for the best platform to run Informix-OnLine on Intel.
>I've tested some versions on my Celeron-333 with 64 Mb RAM and
>single 6.4 Gb Quantum Fireball HDD. I've tried to dbimport database
with
>
>100 tables, 110 Mb unloaded data, ~40 search indexes and
>~200 referential constraints, and UPDATE STATISTICS MEDIUM for almost
>all tables.
>
>All servers were configured with 4000 buffers, 6000 locks, 2 Mb
physical
>log,
>3Mb logical log and 6 logical logs. Import into non-root cooked
dbspace.
>
>Overall times are:
>
>IDS-Personal Edition Win95 - 22 min
>IDS 7.23 Solaris 2.5 - 34 min
>IDS 7.30 RedHat 5.2 - 65 min
>
>Any comments - why so long on RedHat?
Interesting. Did you do any kernel tuning on Solaris or RedHat? I find
it hard to believe that Solaris on Intel could beat anything... :-)
Ah, I've just noticed the Informix version difference. 7.3 may well have
some extra tuning required or some additional environment variables set.
HTH,AIDI. :-)
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
Obnoxio The Clown wrote:
> >now I'm looking for the best platform to run Informix-OnLine on Intel.
> >I've tested some versions on my Celeron-333 with 64 Mb RAM and
> >single 6.4 Gb Quantum Fireball HDD. I've tried to dbimport database
> with
> >
> >100 tables, 110 Mb unloaded data, ~40 search indexes and
> >~200 referential constraints, and UPDATE STATISTICS MEDIUM for almost
> >all tables.
> >
> >All servers were configured with 4000 buffers, 6000 locks, 2 Mb
> physical
> >log,
> >3Mb logical log and 6 logical logs. Import into non-root cooked
> dbspace.
> >
> >Overall times are:
> >
> >IDS-Personal Edition Win95 - 22 min
> >IDS 7.23 Solaris 2.5 - 34 min
> >IDS 7.30 RedHat 5.2 - 65 min
> >
> >Any comments - why so long on RedHat?
>
> Interesting. Did you do any kernel tuning on Solaris or RedHat? I find
> it hard to believe that Solaris on Intel could beat anything... :-)
>
> Ah, I've just noticed the Informix version difference. 7.3 may well have
> some extra tuning required or some additional environment variables set.
Solaris 2.5 patched by bundle of recommended patches from SunSolve.Redhat
5.2 patched by 3K-file-descriptors-patch recommended by Informix.
I didn't perform any tunings specific for any given version of Informix.
Of course I've played with NUMAIOVPS, RA_PAGES, RA_THRESHOLD,
RESIDENT, PHYSBUFF, LOGBUFF, LRUS, LRU_*_DIRTY, CLEANERS
and also raw/cooked dbspaces (it took me 2 days). Tunung' effect never costs
more than 10 percent on RedHat.
Leonid
Obnoxio The Clown schrieb: > > > >Overall times are: > > > >IDS-Personal Edition Win95 - 22 min > >IDS 7.23 Solaris 2.5 - 34 min > >IDS 7.30 RedHat 5.2 - 65 min > > > >Any comments - why so long on RedHat? same at my box. 2.0.36, RedHat 5.2, 256MB Ram IDS 7.30 UC5X1, Oracle 8.0.5 i'm testing our big payroll-system on linux. Overall times are: Oracle - 17 min Informix - 1 hour 50 min!!!! same program, same data!! > Ah, I've just noticed the Informix version difference. 7.3 may well have > some extra tuning required or some additional environment variables set. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ please, tell me more! bye klaus -- Klaus Thiele - Personal & Informatik AG mailto:kth@piag.com "Since I have taken all the Gates out of my computer, it finally works!!"