Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
u1hcw9nx
54 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
54 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.
Consider applying for YC's Fall 2026 batch!
Applications
are open till July 27.
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.