Re: Why IDS-Linux is so slow?

Obnoxio The Clown wrote: > > >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? > > > >> 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... That could be the problem. Try setting NO_SUBQF=1 with 7.30 to turn off sub-query flattening. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+