Meta Interview Question

Given a database with slow I/O, how can we improve it?

Interview Answers

Anonymous

Sep 21, 2015

Using Cache solutions. You preload the database to the cache on system startup, and make all read and writes to the cache. the cache is responsible to update the DB underneath.

1

Anonymous

Nov 11, 2015

One simple solution is using cache or RAID mechanisms (parallelism). But anyway there is no correct answer for this questions, it depends of your specific problem or workload.

Anonymous

Oct 31, 2019

Split the DB onto multiple physical drives or better still, you split the table on multiple drives. In that way, the speed of I/O operations is improved significantly since more heads fetch data concurrently.

Anonymous

Aug 29, 2015

This was a systems design questions that was purposefully open-ended. There's no real right answer, only more depth into the question itself.