Hacker News new | ask | show | jobs
by u1hcw9nx 5 days ago
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.

1 comments

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.