Topic: Faster Search Query
Really looking for some advise on how you would tackle this problem. I am building a hotel room search system. So basically a user can come to the site and search for available room's for a given area, city etc.
Doing the search based on location or facilities is not a problem but only showing available rooms is. A room would already have multiple future bookings so basically a bunch of blackout dates. A good example of what I mean would be like the airbnb site. You can search for properties and give checking-checkout dates. It will then only show you the available rooms.
While I don't think the query wouldn't be that bad I can see it being slow when you have 1000's of blackouts across many rooms.
Can you suggest any good workarounds for performance ie using other technologies like redis, elasticsearch? If so how can you explain how you would achieve such a thing.
Really hope someone can advice and thanks for your time.