You Shouldn't Use SQLite

Re:You Shouldn't Use SQLite by themk on Thursday April 28, 2022 @03:06AM (#31189556)

So, they know they have the wrong index, but they don't know how to CREATE INDEX?

[ Parent | on HN ]

Re:You Shouldn't Use SQLite by Existenceblinks on Thursday April 28, 2022 @03:10AM (#31189587)

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.

[ Parent | on HN ]

Re:You Shouldn't Use SQLite by compressedgas on Thursday April 28, 2022 @03:39AM (#31189761)

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.

[ Parent | on HN ]