Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
Existenceblinks
on April 28, 2022
|
parent
|
context
|
favorite
| on:
You Shouldn't Use SQLite
It's strange article, so I posted here to seek out what's the problem. If they search for non-index column it's very likely to do table scan.
compressedgas
on April 28, 2022
[–]
And the cost of that table scan could have been reduced if the table they had to scan over didn't contain the large text column which has the contents of their files.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: