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