9.40 vs 9.21 performance
Posted in 2004
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