Unanswered: Performance question: check by date or check by bool?
This is just a simple question about performance: say you have a big list of events, some past and some in the future. The past events will not be used other than for statistics. What's the best way to query the database about future events:
I really meant to ask if calculating this by date was slower than an other way (I gave the example of a bool, but it could be a tinyint or enum). Is would seem that checking for a "flag" is quicker than comparing dates.