i would add a second table and also store the totals
in the lyrics table like you suggested
then you can do things like top 10 this week / top 10
this month and make sure its not being abused
LYRICS_RATINGS - id | lyric_id | rating | vote_date |
remote_addr
same idea for hits/impressions
olinu
ive a table called 'lyrics' which is the main content on my site, song
lyrics. im thinking of introducing rate this lyric and all that kind of
stuff into the site. would it be better, from a design point of view, to
create a second table for lyrics ratings and hits or just add a 'ratings'
and 'hits
