Add index to `count`

Open jeffchuber opened this issue 2 years ago • 1 comments

Current count does a full table scan which is quite slow. A first glance suggests this may not be trivial in sqlite.

Jul 26 '23 05:07 jeffchuber

We should speed up count, but SQLite indices don't help. Will have to do it a different way. Likely trigger and update a count.

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

Jul 26 '23 05:07 HammadB

@HammadB could we close this? i think we do this on distributed now?

Jan 28 '25 00:01 jeffchuber