Table Limit

[kwdelre]

I am setting up a new system to record quiz results. There are 15 different quizzes. Should I:

 

1) Use one table for all results

2) Use a table for each quiz

 

One concern I have is that there are around 40,000 quiz attempts in a year. Is there a limit on rows in a table?

 

Thanks for any advice.