Waylon Walker

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

Waylon Walker avatar
Author
1 min read
COUNT slow on big tables — I'm having a performance problem in SQLite with SELECT COUNT(*) on large tables. CREATE TABLE Table1 ( Key INTEGER NOT NULL, ... several other fields ..., Status CHAR(1) NOT NULL, Selection VARCHAR...
COUNT slow on big tables
I'm having a performance problem in SQLite with SELECT COUNT(*) on large tables. CREATE TABLE Table1 ( Key INTEGER NOT NULL, ... several other fields ..., Status CHAR(1) NOT NULL, Selection VARCHAR...
Stack Overflow · 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;

Note

This post is a thought. It’s a short note that I make about someone else’s content online #thoughts

Connections

Related tags and posts connected to this entry.