Migrated from online 5 to online 7.1 now runs slow. -Reply

Dave's original message at bottom We went to 7.10 February 1995 We found that a number of programs that had been tuned for performance under earlier versions of Informix were now running slow under 7.10. The larger select statements in these programs had been heavily de-consolidated because of bugs in earlier versions of the optimiser. By reconsolidating the select statements (and putting ourseleves in the hands of the 7.10 optimiser) we were able to pick performance back up again to higher than the level it had been previously. Also - be careful how Update Statistics is used. Setting up too much metadata can have deleterious effects on performance. If they are using sqlrm to access the database (as you seem to imply) then they can definitely count on a lower level of performance than if they were connecting directly. HTH Regards -- -- Peter Tashkoff NZ Kiwifruit Project Consultant/DBA Marketing Board. Standard Disclaimers apply This posting may not be used by any commercial organisation to vilify another. >>> Dave Ingledew <ingeldew@aladdin.co.uk> 24/May/1996 11:53am >>> Hi. I don't know if anybody can help, I have just been contacted by a friend who unfortunately doesn't have access to this newsgroup. He is currently involved with a company who run a large suite of Informix 4gl programs. Up to about 8 weeks ago they were using Online vers 5 but have now upgraded to version 7.10. The users are now complaining of performance problems. Typically a report which took about 20 minutes to run is now taking somewhere near 4 hours. He has been called in to try and speed things up by modifying the code. He's a switched on guy and he's checked for all the usual things but can find very little wrong with the code. The company previously contacted Informix and one of their guys has been to look at the setup but could find nothing wrong and pointed the finger at the 4gl code. I've seen some references in this group to poor performance if version 7.1x online is used with code that has not been compiled by version 6 i4gl, maybe that's the problem.. The version numbers are as follows: Online vers 7.10D1, i4gl version 6.01UD2. If anybody can throw any light on the subject I would be pleased to hear and will pass it back up the line.. Dave Ingledew