vendredi 6 mai 2016

SQLite managing tables

I'm designing a simple art quiz game. As you can see below picture; there is different categories. My question is; to store questions in sqlite database, should I create 9 different tables for each of period or should I create only one table and put all the questions into a list and then access questions using their id.(0 to 9->ancient greek, 10 to 20-> ancient rome etc.) Which one will be more efficient?

(click Home Page to see the picture)

Home Page

Aucun commentaire:

Enregistrer un commentaire