Re: SMP and 7.x performance questions?

Joe Lumbley (jlumbley@netcom.com) wrote: : That's what I had heard also, and it's wrong. Informix 7.X should : give you **better** performance than earlier versions even on : non-multi-processor systems, due to the improved architecture. : 7.X is a little bit harder to tune though. This is because of the : additional options and parameters that it supports. The onstat utility : is ***greatly*** improved, although somewhat sparsely documented. Joe, Can you expand on this, please. We have degraded performance running under 7.x and it is a real problem. We have tracked one problem to a cursor taking 15+ seconds to open (that is *bad* and we never had that problem under 5.x), but I'm sure there are other tuning parameters we should be looking into. I find the document fairly unhelpful as it simply lists tuning options, but doesn't indicate what or when would be helpful, or how to make those decisions. Thanks Carol Stimmel