datasette icon indicating copy to clipboard operation
datasette copied to clipboard

Mechanism for disabling faceting on large tables only

Open simonw opened this issue 2 years ago • 1 comments

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.

simonw avatar Mar 24 '22 20:03 simonw

would be nice if the behavior was

  1. try to facet all the columns
  2. for bigger tables try to facet the indexed columns
  3. 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!

fgregg avatar Mar 24 '22 20:03 fgregg