Although not as prominent as insert SELECT and UPDATE both benefit from page cac...

andersmurphy 42 days ago | parent | context | favorite | on: The perils of UUID primary keys in SQLite

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.