1 2 3 4 5 Previous Next 63 Replies Latest reply: Jan 22, 2008 9:52 AM by 314771 Go to original post RSS
      • 60. Re: DB Block Size
        Fair enough. But if the low-hanging fruit is all gone... that's when one has to get clever. And maybe, just maybe, there's a table/index that'd benefit a lot from being in a different blocksize. As I said, perhaps it's just too time-consumimg to fiddle about hunting for such candidates.
        • 61. Re: DB Block Size
          Richard Foote
          Hi Harry,

          In my experience, I've yet to come across a perfectly tuned database that is performing poorly and someone says "hey, how about using a larger block size for just those things" and after moving just those things to a larger (or smaller) block size, suddenly performance improves and the day has been saved.

          I really don't think I'm ever likely to either ...


          Richard Foote
          • 62. Re: DB Block Size
            But... how often have you even thought about/tried it? Really, as a percentage.
            • 63. Re: DB Block Size
              Having seen your staspack detailed report, I concluded that
              you need to first tune your application doing all this .

              Tuning it will definitely improve the performance .

              1 2 3 4 5 Previous Next