title: SQLite: Normal Table vs Virtual Table. Which one to choose?
body: <p>I am developing an android application and it uses Sqlite DB for storing and retrieving data. The application has a feature of storing and retrieving text data. I have decided to go with VIRTUAL Table Implementation because of the following benefits</p>
  
  <p>a. Faster Execution</p>
  
  <p>b. Full text search</p>
  
  <p>because my application should be scalable to save large amounts of text data and should be able to search for a particular text quickly. Before starting i have few questions.</p>
  
  <ol>
  <li>Should i go with having only virtual table ? Is it safe for long run ? I read that it is safe to keep a normal table and a virtual table. I don't think it's a good idea to keep 2 copies of same data</li>
  <li>I am planning to index some columns in virtual table to improve search efficiency ? Does this cause any performance and memory overhead ?</li>
  <li>I have 7 columns in the table and the data to be searched is spread across 4 columns. Is it good to go with virtual table or a normal table indexing those 4 columns ?</li>
  </ol>
  
  <p>Thanks in advance</p>