Comment on The perils of UUID primary keys in SQLiteparentComments−u1hcw9nx3moI 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.−andersmurphy3moAlthough 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.
Comments
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.
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.