search

simonw / covid-19-datasette

Deploys a Datasette instance of COVID-19 data from Johns Hopkins CSSE and the New York Times
https://covid-19.datasettes.com/
61 stars 6 forks source link

Johns Hopkins facets timed out: province_or_state, country_or_region #22

Closed simonw closed 4 years ago

simonw commented 4 years ago

https://covid-19.datasettes.com/covid/johns_hopkins_csse_daily_reports

covid__johns_hopkins_csse_daily_reports__429_202_rows_where_sorted_by_day_descending
simonw commented 4 years ago

I'm going to add indexes on these two columns.

simonw commented 4 years ago

I should add an index on day too since that column is used as the default sort order.

simonw commented 4 years ago

Fixed: https://covid-19.datasettes.com/covid/johns_hopkins_csse_daily_reports