RE: 9.40 vs 9.21 performance

Neil Truby > > > We've been trying to expand this into a general case that IBM > Tech Support > will look at, and not been too successful. > This leads me to suspect that the problem may exist with databases and > tables that have been successivley converted from 7 -> 9 -> 9.40 .... > Will keep looking. > > We have just gone live with an upgrade to 9.4 FC2 and one table with 300,000 rows by 107 bytes took consistently 6-7 minutes on an underspecced test servers. On the live server after about 15 hours, we killed the process off, dropped all contraints and indexes, and loaded data in 3 minutes. Constraints and indexes took another 3 minutes. The CPU load during the first attempt was around 90% most of the time. We have not got a clue why !! Colin Bull c.bull@videonetworks.com ________________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. ________________________________________________________________________ sending to informix-list