💭 Sql - Sqlite: Count Slow On Big Tables - Stack Overflow
Waylon Walker
Learning in Public @_WaylonWalker
Tags
Note
This post is a thought. It's a short note that I make about someone else's
content online. Learn more about the process
thoughts
Here's my thought on 💭 sql - SQLite: COUNT slow on big tables - Stack Overflow
Another interesting option for slow count queries in sqlite.
If you haven't DELETEd any records, doing:
SELECT MAX(ROWID) FROM "table" LIMIT 1;
This post was a thought by Waylon Walker see all my thoughts at https://waylonwalker.com/thoughts