issue_comments: 647922203

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue
https://github.com/simonw/datasette/issues/859#issuecomment-647922203 https://api.github.com/repos/simonw/datasette/issues/859 647922203 MDEyOklzc3VlQ29tbWVudDY0NzkyMjIwMw== 3243482 2020-06-23T05:44:58Z 2020-06-23T05:44:58Z CONTRIBUTOR

I'm seeing the problem on database page. Index page and table page runs quite fast.

  • Tables have <10 columns (id, url, title, body_html, date, author, meta (for keeping unstructured json)). I've added index on date columns (using sqlite-utils) in addition to the index present on id columns.
  • All tables have FTS enabled on text and varchar columns (title, body_html vs) to speed up searching.
  • There are couple of tables related with foreign keys (think a thread in a forum and posts in that thread, related with thread_id)
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
642572841
Powered by Datasette · Query took 1.393ms · About: github-to-sqlite