title: Ram overflow and long loading times, SQL query big data
body: <p>I have an existing database from which I need to extract a single record that contains a total of 10 GB of data. I have tried to load the data with</p>
  <pre><code>conn = sqlite(databaseFile, 'readonly')
  GetResult = [
              'SELECT result1, result2 ...... FROM Result '...
              'WHERE ResultID IN ......'
              ];
  Data = fetch(conn, GetResult)
  </code></pre>
  <p>With this query, the working memory increases (16GB) until it is full, and then the software crashes.
  I also tried to limit the result with</p>
  <pre><code>'LIMIT 10000'
  </code></pre>
  <p>at the end of the query and browse the results by offset. This works, but it takes 3 hours (calculated from 20 individual results) to get all the results. (Database can not be changed)</p>
  <p>Maybe someone of you has an idea to get the data faster or in one query.</p>