Let say I have a website with a lot of radio playlist data. We store the name of songs being played on the radio. The database will have around 3 million rows (1 every 5 minutes for every radio station for years) and will keep growing.
So these are the characteristics:
- Songs can have one or more titles
- Songs can have one or more artists
- Artists can have one or more names
- Songs have multiple airtimes (played at
xtime onradio x)
The most queries are based on radio and time. E.g. get the last 50 songs played on radio x. Searching for all the airtimes of a given artist (or song) is also important.
I hope I don't get an answer with "it depends" ;-)
Aucun commentaire:
Enregistrer un commentaire