does the db blocksize matter for inserts ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: does the db blocksize matter for inserts ?

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    does the db blocksize matter for inserts ?

    would the db blocksize play a major role on heavy inserts into a table:

    8K vs 16K ????

  2. #2
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    It depends how big your rows are! How long is a piece of string?
    I think you are probably better of with the smaller block size (8K), this is what oracle recommend for an OLTP environment.
    Your time would then be better spent worrying about other aspects of performance tuning.


  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: does the db blocksize matter for inserts ?

    Originally posted by khussain
    would the db blocksize play a major role on heavy inserts into a table:

    8K vs 16K ????
    Yes it does...

    Inserts on smaller blocks is better and Reads on larger blocks is better.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Re: does the db blocksize matter for inserts ?

    Originally posted by adewri
    Inserts on smaller blocks is better
    Any justification?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    I think im thinking something else....
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Whass tha ?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width