IDS 7.30 very slow
Posted in 1998
Hi,
We are running IDS 7.30 UC2-1 on HP-UX 10.20 and have found it to be so
slow that we have now reverted back to ODS 7.24.
A Newera 3.11 build of a 5 file exe with the repository update enabled with
3 additional library files now takes 15 minutes as opposed to 1.5 minutes.
We have narrowed the problem down to the delete phase of the repository
update, and have noticed that in general delete operations do take longer
with 7.30.
Newera certainly does not treat the server very nicely with a repository
update but the following onstat -p screen captures were done immediately
after a build. Note the uptime of the server and the isamtot and lockreqs
!!!
INFORMIX-OnLine Version 7.24.UC1 -- On-Line -- Up 00:03:41 -- 42440
Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
5269 5287 771630 99.32 1001 4099 99513 98.99
isamtot open start read write rewrite delete commit
rollbk
231136 19401 33381 55746 22132 550 6089 3811 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 39.96 5.39 2 4
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
363 0 565777 0 0 2 661 3356
ixda-RA idx-RA da-RA RA-pgsused lchwaits
2215 0 8 2176 0
Informix Dynamic Server Version 7.30.UC2 -- On-Line -- Up 00:16:15 --
42648 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
33609 73478 19905626 99.83 6702 35546 84869 92.10
isamtot open start read write rewrite delete commit
rollbk
16084227 9915 3473284 5854385 906630 135 5075 6693 1
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 662.80 12.87 5 10
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
663 1 8906248 0 0 5 560 1110
ixda-RA idx-RA da-RA RA-pgsused lchwaits
2283 0 1039 3320 0
Be very careful with 7.30 and test it before committing.
--
Richard Lewis
Gerling Global Group (Australia)
(To reply please remove the "nospam")