Re: On-Line 7 Performance

Which version of SCO Openserver you are using. If you are using 5.0.0 then you have to have patch update for aio and sued drivers from SCO. If you have already done that then try using update statistics for the entire database and try changing the OPTCOMPIND TO 0 This makes optimizer to behave like earlier version of Informix. Other than this there should not be any problem Kalyan Andrew Mercer <amercer@iap.net.au> wrote in article <331606A3.1EAB@iap.net.au>... > We too are having performance problems similar to other postings in this > newsgroup. I suppose it is the nature of newsgroups that only problems > are posted, but are there any sites that are happy with On-Line DSA. > > I have implemented recommedation made here and also from Informix > support, but nothing has made a significant difference. I would be > interested to here from sites that have successfully tune On-Line DSA. > > For the record, our site is using On-Line 7.2 for SCO OpenServer on a > Quad Pentium 60MHz and a Dual Pentium Pro 200 MHz. We have gone back to > our old setup of On-Line 5.03 wich out-performs On-Line 7 by about 60%. >