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

[Nonchaianon (Non)]

Dear elasticsearch technical

I’am developer Food delivery platform

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

Condition

-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

[warkolm (Mark Walkom)]

Welcome to our community!

@Nonchaianon

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

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