vendredi 27 novembre 2015

How Can I Best Perform This Kinda Of Table Relationship?

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