Re: Disappointing test results from 9.40

"Rich Campbell" <rich.campbell@att.com> wrote in message news:bql0qm$q3c19@kcweb01.netnews.att.com... > Neil, > > I see the same. > > We are using 9.40 FC2 for Solaris 2.8. > > A bug has been opened for my case: > > Index builds taking 50-300 % longer then in 7.31 regardless of amount of PDQ > resources allocated. Slowness shows up with larger tables. In our case > 150-800 mill rows. > > Support says that the engine is erroneously writing empty pages to the > physical log when building the index. A fix is slated. > onstat -D will confirm this behavior for 9.40 FC. You will not see thisin > 7.31. > Hmmm. After analysis, I don't think your bug *is* our problem. Tech Support gave us a workaround for your problem, which was basically to enable logging - apparently under this bug the index build will run more quickly with logging enabled than not. But in my tests, 9.40 FC1 or FC2, is no quicker nor slower with logging on than off, and still slower with 9.21 FC4 with logging off. And 9.21 FC4 with logging on is not substantially slower than 9.21 with logging off. Allied to the fact that the defrag with no indexes at all is also slower on 9.40 than 9.21, I think we need to find another explanation. I have an outstanding action to provide more data for UK Tech Support, and will continue with that. thanks and regards Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com