What algorithm shows the distribution of commodity prices on the sidebar when I search Rakuten Market?

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.

sql algorithm

2022-09-30 19:54

1 Answers

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🍀

2022-09-30 19:54

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656