I just want to know how they came to 8kb when striking a balance between:
smaller page = more page splits
bigger page = longer to look through to find value
I expect there are many more pros and cons to having a bigger page but if we could start again would we pick 8kb again?
I'm not saying it's the wrong decision and I know it would be a massive change to the product to alter the size.
Also I know 8kb was chosen a fair few years ago now and I wonder does it still make sense when rows are likely to be longer now due to new data types?
Asked by James Anderson
(5794 rep)
Jun 5, 2014, 04:34 PM
Last activity: Jun 6, 2014, 03:38 AM
Last activity: Jun 6, 2014, 03:38 AM