issue_comments: 550649607

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/607#issuecomment-550649607 https://api.github.com/repos/simonw/datasette/issues/607 550649607 MDEyOklzc3VlQ29tbWVudDU1MDY0OTYwNw== 8431341 2019-11-07T03:38:10Z 2019-11-07T03:38:10Z NONE

I just got FTS5 working and it is incredible! The lookup time for returning all rows where company name contains "Musk" from my table of 16,428,090 rows has dropped from 13,340.019 ms to 15.6ms. Well below the 100ms latency for the "real time autocomplete" feel (which doesn't currently include the http call).

So cool! Thanks again for the pointers and awesome datasette!

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 512996469