Re: Informix Online Performance

Posted in 1996

Kevin Brand — 11 Dec 1996 22:30:24 GMT — source: Informix-list mailing list archive (1991-1998)

Are your applications creating any temp tables ( explicit or implicit ) ? If so, and they do not use the WITH NO LOG option, you're likely to see quite a bit of Logical Log traffic as well! Kevin Brand mike aubury <mike@aubury.demon.co.uk> wrote in article <32ACE11A.7238@aubury.demon.co.uk>... > I'm a Contractor, and in my current job running on informix online 7.13 > and its running like a dog.... > with no legs. > > They're a huge number of lock requests (more than the cache reads+cache > writes added together) and the applications are mainly run in dirty > read. > > Any ideas ? > Any know problems with Online 7.13 > > Any comparisons in performance Online 7 to Online 5 ? > > Machine: DRS6000 Dual Sparc (Super Server ?) >