When I searched Rakuten Market, what algorithm shows the distribution of commodity prices on the sidebar?
What comes to mind is using SQL's GROUP BY, but
Hundreds of thousands of hits are still displayed very fast and
I think there might be an algorithm that can run fast for aggregation.
I think it is implemented using full-text search engine functionality, not SQL.
Specifically, Apache Solr's facet, Elasticsearch's aggregation.
"There is an example in the ""Send queries for facets and introduce the function of creating facets with the results"" section of this site."
Try facet in Apache Solr 5.x - CLOVER🍀
© 2025 OneMinuteCode. All rights reserved.