Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
u1hcw9nx
52 days ago
|
parent
|
context
|
favorite
| on:
The perils of UUID primary keys in SQLite
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
52 days 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.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
Also INSERT speed instead of SELECT? Typically most time is spend in SELECT or UPDATE.