Re: IDS9.2 Performance Problems

In article <T9Dk5.4315$Z2.76166@nnrp1.uunet.ca>, "ASA GSI" <jbruce@asaglobalserv.com> wrote: > I am having a real problem with the performance of our application on > IDS2000 (Ver 9) as compared to IDS7x. IDS9.2 processing time is 45% greater > than that of IDS 7.22. I am just wondering how did you come up with the 45% greater ? Thanh Sent via Deja.com http://www.deja.com/ Before you buy.

I ran IDS 7.2 - 3294 members processed - 1 hour 01 minutes then ran IDS 9.2 - 3294 members processed - - 1 hour 27 minutes the rest is simple math Thanh <tqma@my-deja.com> wrote in message news:8mv1hj$57o$1@nnrp1.deja.com... > In article <T9Dk5.4315$Z2.76166@nnrp1.uunet.ca>, > "ASA GSI" <jbruce@asaglobalserv.com> wrote: > > I am having a real problem with the performance of our application on > > IDS2000 (Ver 9) as compared to IDS7x. IDS9.2 processing time is 45% > greater > > than that of IDS 7.22. > > I am just wondering how did you come up with the 45% greater ? > > Thanh > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

The following is the output of onstat -p Informix Dynamic Server 2000 Version 9.20.UC4 -- On-Line -- Up 06:20:00 -- 66608 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 296 314 115820 99.74 410 706 15311 97.32 isamtot open start read write rewrite delete commit rollbk 163397 10056 16103 50422 4438 187 1539 6 0 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 33.35 9.77 4 152 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 15 0 15403 0 0 0 111 24 ixda-RA idx-RA da-RA RA-pgsused lchwaits 16 0 7 23 0