title: Checking if date in date range in Python but over 100k records
body: <p>We are trying to overhaul a scheduling application at the moment. It is written in Python/Django and using DRF to power a React frontend.</p>
  
  <p>I just have a quick question- apologies if this has been answered already.</p>
  
  <p>I have seen Dietrich Epp's answer to this problem on <a href="https://stackoverflow.com/questions/10747974/how-to-check-if-the-current-time-is-in-range-in-python">this thread</a>.</p>
  
  <p>I am just wondering if I have to check if a time is between two datetime objects over 100k records, what the fastest way to achieve this is?</p>
  
  <p>I have considered indexing all of the datetimes in Haystack so that Elasticsearch can deal with the searching but do not want to overcomplicate if it can be solved simply.</p>
  
  <p>Thanks all!</p>