issues: 782708469

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app
782708469 MDU6SXNzdWU3ODI3MDg0Njk= 1183 Take advantage of sqlite-utils cached table counts, if available 9599 open 0     2 2021-01-09T23:51:48Z 2021-01-12T02:42:08Z   OWNER  

sqlite-utils 3.2 now has a mechanism for creating a _counts table with triggers to maintain counts for individual tables. Datasette could look for this table and use it for counts, dramatically speeding up places that currently suffer from slow counts. Refs #859.

https://sqlite-utils.datasette.io/en/stable/python-api.html#cached-table-counts-using-triggers

107914493 issue    

Links from other tables