title: Optimising Bulk Select statements for SQLite
body: <p>I have a database table:</p>
  
  <pre><code>id INTEGER PRIMARY KEY
  , X INTEGER
  , Y INTEGER
  , Value INTEGER
  </code></pre>
  
  <p>There are 1,050,625 records, and I call them using</p>
  
  <pre><code>SELECT Value
  FROM Tablename
  </code></pre>
  
  <p>I just want all the records from the fourth column. My function stores these into an array, but getting all this data takes nearly five minutes.</p>
  
  <p>Is there a faster way to get this data?</p>