Im designing a soccer betting site for fun and learning purposes.
Say i have 1000 users in table db_users
and i have 10 open games to bet on. i have this table structure
matchid, team1, totalbetonteam1, team2, totalbetonteam2
i want to store what user bets on what team and how much. i dont really now performance wise how to handle that. ill figured ill mal a table
usernaname, machid, team, amountuserbetonteam
bob, 12, 1, 3$
but what if i have 1000 users all betting in each matchup on each team a little bit.
i have 1000 (users) x 10 (open games) x 2 (teamcount) = 20000
this gets worse with every matchup/user/team
20 thousand rows is fairly small
call us when you get to 20 million