jeudi 10 décembre 2015

Best practice for handling multiple relation in SQLite table in android

I have lot of data received from server in json format. I am saving this data in SQLite database in Android. Since The database operation must be very fast in android (Because I don't want to show a loader unnecessarily until the db query completes). So for concerning this, I haven't used the table normalization (Say foreign concept).

For an instance: I have saved my json data in SQLite table each key corresponding to a Column name. And I saved one or two ArrayList in one column of table as json array.

Is it a fine approach in Android or should I make another table for this array list values And the link it through Foreign Key?

Please suggest should I create multiple number of tables with foreign key (if needed) Or I can store some data in one column of table in json format.

Aucun commentaire:

Enregistrer un commentaire