i'm developing Fantasy App.
I create one table called 'Tournaments' and one table called 'Entries'.
I want have the total number of entries for each tournament.
I really don't want query everytime the table 'Entries' to count the number of entries for each 'Tournament'. So i think in put also some column on 'Tournaments' table calling column 'entries_total'.
How is the best way to perform this ?
To resume the goal: Have the total number of tournaments entries in an column on the 'Tournaments' table.
Aucun commentaire:
Enregistrer un commentaire