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

!https://stackoverflow.com/questions/8988915/sqlite-count-slow-on-big-tables

Date: April 1, 2024

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;
```

NOTE
│ This post is a thought </thoughts/>. It’s a short note that I make about someone else’s content online #thoughts </tags/thoughts/>