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

It's silly to make any blanket statements, since platforms and applications vary widely. I can, however, speak of our company's experience with 7.1 thus far (6+ months in production, NCR SMP& IBM SMP platforms). 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 am biased, since administration is my job. In one case, however, we are considering going back to 5.x simply because we cannot get the throughput we need with 7.1. (Have we tuned? Ad Nauseum. Do we have the latest version? Always.) As for DSS applications, where 7.1 is supposed to shine, I'm not qualified to comment. There are some aspects of 7.1, like parallel index builds, that are incredible with certain configurations, and far superior to 5.x. On the other hand, there are still some "quirks" with 7.1 that I like to think will be smoothed out as the product matures. ( BTW, I do see the cup as half-full). The fact that you are slowing down as users are added is contrary to the conventional wisdom that the engine performs better under load. 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). -Johnny ---------- From: informix-list-owner To: informix-list Subject: OnLine 7.X performance - R U satisfied? Date: Thursday, April 11, 1996 11:54AM hi all, i have just installed 7.11 on a sprcserver 20 platform. my migration went well, and when i had about half the company on the system, (approx. 30-40 threads), and the system was running really well. i had it tuned for what i though would be a good approximate starting point, and that turned out to work really well. i've added the rest of the company, (approx. 70 - 80 threads), and now the system is much slower, much more so than i had hoped for by going from approx. 30 to approx 70 threads. so far there doesn't appear to be anything abnormal. my disk activity is realtively light, nothing seems to be hogging memory, my # or ready threads jumps between 2 and 6, my checkpoints are averaging 1 - 4 seconcds, things like this. it seems that this is going to be an interesting process. i have 2 physical cpu's but am running as a single cpu machine. the concensus from the net is anything less than 4 is better off as 1. i might give it a try, but later. my question is this: i've seen a number of posts complaining of installing 7.X and having the system slow down significantly from 5.X or whatever version that was running before. but i don't recall seeing posts about getting the system in tune, and having it run faster or better than before the upgrade. i guess that isn't really a question...:-) can people reply to this, if they have come to the point where they have tuned the system, and it is now running as we would expect, and what they did to get there? considering that i can't find any obvious bottlenecks, i would expect to be seeing at least similar performance to my 5.X system. curiously awaiting replies... mickm