home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 444711254

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 reactions draft state_reason
444711254 MDU6SXNzdWU0NDQ3MTEyNTQ= 467 Index page row counts only for DBs with < 30 tables (10ms count limit per table) 9599 closed 0   4305096 2 2019-05-16T01:21:36Z 2019-05-16T03:03:45Z 2019-05-16T03:03:45Z OWNER  

Split out from #460.

If a database is mutable, calculating row counts gets expensive. I'm only going to calculate row counts for the index page if it has less than X tables (both hidden and non-hidden) AND each table can be counted in less than 10ms.

If any count takes longer than 10ms I'll cancel the counting entirely. We currently show an inaccurate count if this happens, which is just confusing.

107914493 issue    
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/467/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  completed

Links from other tables

  • 1 row from issues_id in issues_labels
  • 2 rows from issue in issue_comments
Powered by Datasette · Queries took 0.92ms · About: github-to-sqlite