Re: Online 5 to 722 Performance

Art S. Kagel wrote: > > Paul Watson wrote: > > > > This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went > > except the 722 runs 75-100% slower than 5. All the index's have been > > rebuilt and updates statistics have been run as per the release notes. > > > > I think I might be seeing the recent 7.23 and 7.24 Tech alert behaviours. > > > > Anybody any ideas. > > > > BTW the box is a Sun 1000/4 Processors/312MB complete with SSA. Raid is not > > being used, neither is mirroring. There are 3 CPUS bound to the engine, > > the disk accesses are all under 8ms. The thread profiles are poor though. > > For best 5.xx like performance make sure that OPTCOMPIND is set to zero > (0) in your ONCONFIG file! You should also go for 7.24UC5 or later or > 7.3UC2 or later which fixes many problems introduced in 7.22 and 7.23. > Also what version of Solaris are you running? Only 7.24UC5 and later > are certified for the latest version of Solaris. > Setting OPTCOMPIND from 2 to 0 makes no difference. Weird eh! After each engine change the 4ge was recompiled, shouldn't make a difference I know but ..... What I find really odd is the following Import the data, run time = 30 minutes Import the data, run 'update statistics', run time = 30 minutes Import the data, run 'update statistics high/low etc', run time = 30 minutes Solaris 2.5.1 and as far as I can tell all the patches are in place. The machine was recently setup by Sun themselves as the Sun reseller was unable to get the box stable. BTW the disk access times are significantly better than under 5. Everything seems to point to either statistics problem or memory. The thread profiles are about 30-40% of what I would expect to see. From the sqexplain there are only index reads and most of them are key-only. > Art S. Kagel -- Paul Watson # WF Software Ltd # If it ain't broke, Tel: +44 1436 674729 # fix it till it is. Fax: +44 1436 678693 # www.wfsoftware.co.uk #