datasette
datasette copied to clipboard
Mechanism for disabling faceting on large tables only
Forest turned off faceting on https://labordata.bunkum.us/ because it was causing performance problems on some of the huge tables - but it would be nice if it could still be an option on smaller tables such as https://labordata.bunkum.us/voluntary_recognitions-4421085/voluntary_recognitions
One option: a new setting that automatically disables faceting (and facet suggestion) for tables that have either more than X rows or that are so big that the count could not be completed within the time limit.
would be nice if the behavior was
- try to facet all the columns
- for bigger tables try to facet the indexed columns
- for the biggest tables, turn off autofacetting completely
This is based on my assumption that what determines autofaceting is the rarity of unique values. Which may not be true!