sql - SQLite: COUNT slow on big tables

@waylonwalker

2024

sql - SQLite: COUNT slow on big tables - Stac ...
https://stackoverflow.com/questions/8988915/sqlite-count-slow-on-big-t ...
Another interesting option for slow count queries in sqlite.

If you haven't DELETEd any records, doing:
```
        
SELECT MAX(ROWID) FROM "table" LIMIT 1;
```

You found my thought's a collection of short posts generally tied to a link on the web and written through a small chrome extension. See full posts on waylonwalker.com

sql - SQLite: COUNT slow on big tables - Stac ...