title: Could not allocate CursorWindow
body: <p>I'm operating on an <em>SQLite3</em> database in my android app. I just read from the pre populated database that has 200k rows and 14 columns. Entries are words. Datatype of all columns is text. Querying for words up to 11 letters (eg. ABANDONMENT) works fine. But for 12 or greater (eg. ABANDONMENTS), the app crashes. Here is the logcat:</p>
  
  <pre><code>Could not allocate CursorWindow '//data//data//com.example.myapp//databases//database.sqlite' of size 2097152 due to error -12.
  threadid=11: thread exiting with uncaught exception (group=0x40adf9f0)
  FATAL EXCEPTION: Thread-2883
  android.database.CursorWindowAllocationException: Cursor window allocation of 2048 kb failed. # Open Cursors=861 (# cursors opened by this proc=861)
  at android.database.CursorWindow.&lt;init&gt;(CursorWindow.java:104)
  at android.database.AbstractWindowedCursor.clearOrCreateWindow(AbstractWindowedCursor.java:198)
  at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:162)
  at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:156)
  at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:161)
  at android.database.AbstractCursor.moveToFirst(AbstractCursor.java:201)
  at com.example.myapp.MainActivity.query(MainActivity.java:815)
  at com.example.myapp.MainActivity$2.run(MainActivity.java:356)
  at java.lang.Thread.run(Thread.java:856)
  </code></pre>
  
  <p>code:</p>
  
  <pre><code>query = "select * from words where col_1 = \"" + (myWord)+ "\";";
  cursor = database.rawQuery(query, null);
  if (cursor != null)                                          
      cursor.moveToFirst(); // line 815
  if (!cursor.isAfterLast()) {
      do {
          for (i = 1; i &lt; cursor.getColumnCount(); i++) {
              temp = cursor.getString(i);
              //other stuff
          }
      } while (cursor.moveToNext());
      cursor.close();
  }
  </code></pre>
  
  <p>So what does the error mean and why is the app crashing?</p>