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

clem, > 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. this is very true. it is an unfortunate situation here in that there are a *lot* of applications running, and i won't have much, if any, cooperation from various departments in reviewing applications. still, i would assume that a 7.X engine, in reasonable tune, should at least match the performance of a 5.X engine under the same loads. my overall impression is this: the system is running quite well, in a lot of cases at least as good as the 5.06 we were under, but multi-table queries are running *much* slower. i haven't really started looking into it yet, as there are higher priority things at the moment, i.e. contrary to my first post, my checkpoint times are wildly erratic, and so i have to look into things like that. > 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 that is fine, very little if any swapping, more than reasonable amount of paging. for my system, i have loads of memory. > Tuning thought du jour: > "Everything under the sun is in tune > but the sun is eclipsed by the moon." and remember, there is no dark side of the moon really, as a matter of fact, it's all dark.... mickm