Re: Informix on NT or UNIX

In article <6m7s7r$neh$1@news.xmission.com>, Billy Wheeler <billy@west.co.za> writes > >On 16 Jun 98 at 13:18, Hofinger, Christian wrote: > >> There are batch processing every week. It was running for 10 hours. >> Since last process it needs more than 20 hours. >> >> What can be the reason for this increasing of time ?? > >Have you run UPDATE STATISTICS lately? > Check the ww.iiug.org software for util2_ak which includes the wonderful dostats.ec!! PS I've sent in some patches to run against SE v7 as well! Also check OPTCOMPIND=0 in $ONCONFIG. Check you have the right indexes. Run the sql in dbaccess with SET EXPLAIN ON and check how the sql is being processed and make sure indexes are being used.. >> Now, we are looking for a better system : Informix on NT ?? > >No. > >-- > >Ciao, >Billy > >/Group Managing Director, The West Solutions Group: http://www.west.co.za >\\ Drivel @ http://www.west.co.za/tastel >ess/ >/ >\\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the >company and I >/ think we should go along with him..." >\\_______________________________________________________________________________ >_________________ -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care