Subject query data of restaurants by given location topic that we desire for a year

Dear elasticsearch technical

I’am developer Food delivery platform

We desire to improve performance query data of restaurants by given location


-50,000 restaurant

-200 km^2

-queries 200,000 times per day

Solution 1

We geospatial restaurants 500 restaurants/index/cluster by using H3 totally 100 index.

When user query by given location we pull the specification index relevant index.

Solution 2

We store 50,000 restaurant in 1 index but we using geo query by Elasticsearch which claim efficiency query large data

Please suggestion which solution are improve high performance and using low resources of sever

Welcome to our community! :smiley:

Your best option is to test both solutions on your dataset, your queries and your cluster and see which is faster.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.