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