Re: DSA 7.22.UC1/HPUX 10.20

David Coburn wrote: > > Hi. I have an odd problem here. DSA 7.22.UC1 is demonstrably > slower on my HP 9000/K420. I have an EMC disk array with 56Gb > attached, 4 cpu's and 1Gig real memory. Disk I/O screems > during insert/update, performance is beyond reproach during > index builds, etc. The problem is that queries are slow. This > wouldn't be much of a problem, except that we're replacing an > old Unisys running 7.10.UC5 that should be 5-7 times *slower* > than the HP, based on the usual metrics. Queries, though, that > take sometimes hours longer to complete. > > We've checked all the usual suspects. Indexes are in place, Agreed - it hould run a bit quick - but your list of usual suspects didn't include the results of setting sqexplain on. Ian