2 ms·
Search indexes like Solr and Elasticsearch have the ability to calculate multiple facet counts efficiently in a single operation. My application Datasette runs
by simonw 3y ago
Search indexes like Solr and Elasticsearch have the ability to calculate multiple facet counts efficiently in a single operation.
My application Datasette runs a separate SQL query for each one, which works fine if you are using SQLite and only have a few hundred thousand rows of data.