Re: Why IDS-Linux is so slow?

Posted in 1999

Obnoxio The Clown — Thu, 18 Feb 1999 16:51:49 GMT — source: Informix-list mailing list archive (1991-1998)

>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! I'm clutching at straws here (because I don't have any access to 7.30), but I seem to recall some posts on things like sub-query flattening and some such. Sorry it's a bit vague. Try searching DejaNews... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com