Which is the best way to design a db schema in which store hundreds of thousand events, with recurrencies, and that will support milions of query asking which events will occur in a range of dates?
I mean, designing the tables to describe the model should be not difficult, but doing that in such a way that the huge amount of data can be searched quickly... well, I have no idea of how to do that.