title: SQLite Querying - Very slow for large data set
body: <p>I'm currently running a query that looks as such:</p>
  
  <pre><code>    Select Name from Location Where Created &gt; (long value of date)
      and 
      Created &lt; (long value of date) and LocationContainer = 'a string'
  </code></pre>
  
  <p>Long value of date meaning milliseconds since Epoch, we use that for storing dates.</p>
  
  <p>I have a index built on <code>LocationContainer</code>, Created in that order.</p>
  
  <p>I have a query that returns 1.3 million rows, but it also takes about 40 seconds to run. Is that right? Shouldn't this query be much much faster sinc ethe fields i'm querying on are indexed? What am I missing?</p>