Waylon Walker

sql - SQLite: COUNT slow on big tables - Stack Overflow

Waylon Walker avatar
Author
1 min read
database sql sqlite thought
Copy this post
External Link
stackoverflow.com

Another interesting option for slow count queries in sqlite.

If you haven’t DELETEd any records, doing:

SELECT MAX(ROWID) FROM "table" LIMIT 1;