We are building a hotel reservation system. There will be 5000 hotels and each hotel can have up to 10 room types. The rates for each room depend on selected dates and number of adults. We are planning to prepare precalculated prices for every possible combination (1-10adults x 3-14lengthOfStay x 365days). Can we use Elasticsearch to store all the precalculated rates, in order to do quick sorting and filtering of hotels?
Thank you