Database values do not appear during first time use of my application

Question

I am creating a database using a DataHelper class and then creating a table using FTS virtual table. The values are being imported from the text file in RAW folder which contains 1000 entries and a total file size of 64 kB.

But during the first time use the data values are not appearing during table query as though the full table is not yet created. Perhaps the file size is not at all huge(64 kB). The values appear when i restart the application and again make the query.

Is there any solution for this??

Surely there is a solution. But some of your code would be helpful. — Darokthar, Jul 05 '11 at 11:36

score 0 · Accepted Answer · edited May 23 '17 at 10:24

0

There is a solution: you can package your SQLite database in the APK and copy it on first run. That way you will avoid long initial population... More about this solution: Ship an application with a database

edited May 23 '17 at 10:24

Community

1
1

answered Jul 05 '11 at 13:48

Ognyan

13,452
5
64
82

thank you.. I read that article long time before but could not recall it.. Thanks again.. – ashish Jul 05 '11 at 17:51

Database values do not appear during first time use of my application

1 Answers1