title: What I should pick - JSON or SQLite?
body: <p>In my application, on every launch at first some <code>JSON</code> have to downloaded from server and later I need to show various information by parsing this data one the full app life-cycle. The <code>JSON</code> object is pretty big with almost 5000 <code>JSONArray</code>. Every JSON array is of the following form:</p>
  
  <pre><code>[37,101,"The Blocks Problem",9952,0,1000000000,0,852,0,0,11197,0,16606,0,7279,200,18415,5325,14492,3000,1]
  </code></pre>
  
  <p>So I have two option:</p>
  
  <ol>
  <li>Save the json string into a file and later read it.</li>
  <li>Save the JSON array in SQlite database with almost 10 columns and 5000 rows.</li>
  </ol>
  
  <p>The first option seems to be efficient. But later I have to manipulate the JSON for displaying various information. In some cases, I need to search full array to pick on array information and there are many cases like this. So this would be very time consuming also.</p>
  
  <p>The second option is better for searching and displaying faster. So I approached on with the second option. But the insertion of 5000 rows at a time is time consuming also. I did it in <code>AsyncTask</code> for betterment but it is taking too much time to be executed - parsing JSON and store in <code>SQlite</code> table.</p>
  
  <p>So what can I do? what is the best way to store this huge information and later use it efficiently?</p>