Re: OnLine 7.X performance - R U satisfied?

mickey.mestel@etak.com (Mickey Mestel) wrote: >johnny, >>For OLTP applications, performance is no >> better and in some cases worse >> when compared to OnLine 5.x. For me, the administrative improvements >> in 7.1 make up for whatever is lacking in performance, in most cases. But I > i think that is usually the case, although when you can bring the >pdq stuff into play, then the performance is there. >> The fact that you are slowing down as users are added is contrary to the >> conventional wisdom that the engine performs better under load. > i think that as 7.X is designed as a multiprocess, multithreaded >engine, in a >4 cpu enviornment, it probably screams. i don't >know that it is any real gain in a smaller enviornment over 5.X, as >bourne out by a lot of the discussions, but then informix would limit a lot >of exposure if it sold it this way. > as an example, go to >http://www.dbintellect.com/archit~1/informix/DBINFRM.HTM to check out a 200gb >database, on a 36 cpu SGI machine. impressive! >> Again, this is our experience only. I'm sure there are many success stories >> and I would like to hear them (from >> someone not in marketing, preferably). > i would like to as well. i know there are systems running quite well >out there, i just want to hear about them, and what they did to get there. >i think that for two days in production, my system is running quite well, and >i think that i should be able to get it running better within a few weeks. It would probably help somewhat if you could post the contents of your onconfig file. -- Melvin Mariney, Informix DBA e-mail: melvin.mariney2@bridge.bellsouth.com