4 ms·

I can't believe I had to scroll down to this far to see someone making this point. Also INSERT speed instead of SELECT? Typically most time is spend in SELECT

I can't believe I had to scroll down to this far to see someone making this point. Also INSERT speed instead of SELECT? Typically most time is spend in SELECT or UPDATE.

andersmurphy 5mo ago
Although not as prominent as insert SELECT and UPDATE both benefit from page cache locality, assuming rows that are stored near each other are often selected/updated together.