Re: 9.40 vs 9.21 performance

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. "Neil Truby" <neil.truby@ardenta.com> wrote in message news:... > Has anyone done performance tests of 9.21 against 9.40 ("level 0")? > > We have, and found 9.40 to be much slower. > > We've tried to break this down on one table, and I reproduce the results > below. > > The problem seems to be with the rate of insert of new rows. > > We're working on digging deeper (can we reproduce it on any table, do we get > the same with indexes dropped etc?) before opening a Tech Support case, in > order to make the call as generic and reproducible as possible. > > Any comments gratefully received. Thaniks to the marvels of SAN technology, > you can be sure that the tests were done in identical circumstances save for > the IDS version. > > (For reference: 9.21 FC4, 9.40 FC3W2 on HP-UX 11.11). > > thanks > Neil > > ============================================================================ > == > IDS9.21 - Bench Mark Testing > Informix Dynamic Server 2000 Version 9.21.FC4 > Database unload - table COLINE > Database selected. > 222284 row(s) unloaded. > Database closed. > > real 3:36.10 > user 2:37.95 > sys 4.20 > > Database delete - Table COLINE > 222284 row(s) deleted. > Data committed. > Database closed. > > real 27:05.74 > user 0.04 > sys 0.03 > > Database Load - Table COLINE > Database selected. > 222284 row(s) loaded. > Database closed. > real 1:09:37.28 > user 1:49.94 > sys 5.09 > > IDS9.40 - Bench Mark Testing > IBM Informix Dynamic Server Version 9.40.FC3W2 (Expanded chunk capacity > mode: disabled) > Database unload - table COLINE > Database selected. > 222284 row(s) unloaded. > Database closed. > > real 3:37.50 > user 2:30.99 > sys 4.46 > > Database delete - Table COLINE > Table locked. > 222284 row(s) deleted. > Data committed. > Database closed. > > real 26:24.11 > user 0.07 > sys 0.04 > > Database Load - Table COLINE > Database selected. > 222284 row(s) loaded. > Database closed. > real 2:01:46.36 > user 1:51.89 > sys 4.70 > >