Buffer pool in a database
In this post we’ll try to explore what a Bufferpool is and why its needed in a database. Any database we use needs to access file on disk either to read or write data. Disk access is slow. So we have to try to minimize this disk access. How can we minimize disk access ? We can cache the data in memory. Reads/writes can be done in memory and the in-memory data can be flushed to disk when required....