Re: Performance problems in SAP R/3 with informix 7.3

From: "Christian Kondo" <christian_hk@hotmail.com> > >Let me tell you my case, >I was very happy with 7.24.uc3 version and I didn't know it ... >My database has almost 250Gb, and my main problem was one table (ausp) with >25Gb. When I run update statistics in this table, it becames to use a wrong >index, can you imagine it ? Of course I can... :-) >There are almost 500 users in this system. >The decision was to do an upgrade to 7.30.UC7.XB (release from SAP), after >this many queries are very sloooowwww. So, next decision, other upgrade to >7.30.UC7.XK. The oncheck -cd (in single user) before XK took 12 hours and >now 32 hours ! We tried to change memory parameters, but it didn't solve >the entire problem... The consultants SAP are in system right now, but ... >I'd want to know if somebody had any performance problem with 7.3x with SAP >and if had any solution. There are lots of problems with the 7.30 optimiser (allegedly) which are fixed in the 7.31 optimiser (allegedly). I don't know why you're doing an oncheck -cd for the fun of it...? Did XK solve your query problem? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com