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

> [...] > 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've moved systems from 5.x to 7.x and been satisfied with the performance. Here are two things you did not mention in your post: 1) Application tuning. Are there tables or rows being locked by users? What is the default locking level? What is your isolation level? Historically, most performance gains can be found in the application itself. 2) Memory usage. Is your machine paging or swapping excessively? You may use onperf (detailed in the book "Informix-OnLine Dynamic Server Performance Guide) or your operating system's memory management commands to find out. Tuning thought du jour: "Everything under the sun is in tune but the sun is eclipsed by the moon." P. Floyd Be sure to post your success story when you get it figured out! ;) ____________________________________________________________ | Clem Akins clema@informix.com | | International Support formerly | | Informix Software, Inc cwakins@leia.alloys.rmc.com| | Menlo Park, CA Standard Disclaimers Apply | |___________________________________________________________|