title: big sqlite database in android application
body: <p>I am trying to build dictionary app(actually it is a modification of google SearchableDictionary sample), whose source of words and their definitions is very big, around 5MB. I tried many ways and using many formats and it still cant run properly on android. Sqlite database should be the best solution, I have built it and its size is 10MB(tried building it both before runtime and during runtime).
  The main problem is the size of the definitions, but I have seen some other applications have managed to do this. It might be that there are some file size limits built into android system, but anyways if they werent it all takes so much to search and run queries in this sqlite database.</p>
  
  <p><strong>What am I doing wrong?</strong>
  BTW: It HAS to be offline dictionary (download definitions max 1 time).</p>
  
  <p>Problem in a nutshell:</p>
  
  <pre><code>word -definition 
  word2 -definition2...
  </code></pre>
  
  <p>Stored in a 10MB sqlite database (tried loading it from assets), not working.
  With some hacks (loading it manually with eclipse DDMS tool) it is working but terribly slow.</p>