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

clema@informix.com (Clem Akins) wrote: >> [...] >> 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. Have you got this book with the 7.10 documentation ? > >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 | > |___________________________________________________________| -- +------------------------------------------------------+ | . . | Liam Kenneally | | ... ... | email : kenneall@cork.cig.mot.com | | ..... ..... | phone : intl +353 +21 511381 | | .. ... .. | fax : intl +353 +21 357635 | | . . . | post : QCOR155@email.mot.com | +------------------------------------------------------+