Re:Reasons to replace advanced search with filters
by simonw on Sunday August 27, 2023 @02:54PM
(#37285549)
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.
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.