Re: 4GL program goes slow

Posted in 2000

HishamAR@mesiniaga.com.my — Thu, 6 Jan 2000 15:24:36 +0800 — source: Informix-list mailing list archive (1991-1998)

Octav, yup, i ran update statistics for the database and it gave index problem which i have corrected later that day. thanks, regards, Octav Chiriac <com@netinfo-moldova.com> on 06/01/2000 06:38:47 AM Please respond to com@netinfo-moldova.com To: HishamAR@mesiniaga.com.my cc: informix-list@iiug.org Subject: Re: 4GL program goes slow Have you run update statistics (and I mean the correct update statistics, try getting Art's dostats program from www.iiug.org) ? Best Regards, Octav On Thu, Jan 06, 2000 at 12:49:18PM +0800, HishamAR@mesiniaga.com.my wrote: > hi guys, > > Recently i have upgraded my INFORMIX 4GL RDS and 4GL ID from 5.X to 7.X (plus OnLine > 5.X to 7.3). i compiled 4gl programs later the day and tested the loading program ( which has > a select statement with not so complex where conditions and summation, and insert statement at the end). Surprisingly > the program took 1.5 days to complete where as it took 2 hours when running the same program > on the older version (5.X). Somebody please clarity me on this. > > i dont see any of the buffer contention when the thing is running and fyi, the engine sits on a single CPU machine. > > thanks in advance -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com