Page Size Selection for OLTP Databases on SSD Storage

Flash SSDs are a technology that has the potential of changing the database architecture and principles. The authors re-evaluate present trend of growing database page sizes considering its validity for SSD-based database storage. Their major findings are: on Flash storage this trend is reverted and best OLTP performance can be attained with smaller page sizes; DBMS with smaller page sizes require less buffer space while providing the same performance; due to the lower response times they report better CPU utilization for small page sizes.

Provided by: Technische Universitat Darmstadt Topic: Data Management Date Added: Oct 2010 Format: PDF

Find By Topic