Re: 4GL program goes slow
Answered: amber (solid confidence) — Only a reply survives (the original question about a 4GL program running much slower after a 5.x->7.x/OnLine 7.3 upgrade is quoted, not archived separately); it gives the classic, plausible fix (run correct UPDATE STATISTICS via Art Kagel's dostats), but is never confirmed by the original asker.
Advisory only.
Posted in 2000
Topics: Installation, Setup & Upgrades, SQL Development & Query Writing, Connectivity: ESQL/C, 4GL & Embedded SQL
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