
Database numpty question time
Why does the entire DB need to be in memory, as opposed to just the hottest parts or indexes or memory mapping it or any of the other locality & cache & 80/20 notions that we all teethed on? Is the data being used in such a chaotic way that true random access is the only hope?
<=== I so feel a blonde