Please excuse my lack of knowledge on database deisgn, programming etc is just a hobby of mine.
Concept: A large number (hopefully lol i dream of oneday like 10000) of users register to use this application im creating. Im fine with storing their details etc in a table. Its all good.
The only other thing i need to store in the database is what questions (represented by a number, i.e question 1003) the user has attempted and what mark they got. Im just wondering if the following Table would be an acceptable solution for this.
Table name: UserProgress
Fields: UserID Q# Mark
Now everytime the user completes a question a new entry will be entered into this table, the userID the question number and the mark they achieved.
UserID Q# Mark
Jack 20 5
Jack 1001 9
Now i was doing some numbers, and i figured id prob have around 2000 questions, and possibily 10000 users haha i was thinking wow if each user does most of the questions i could be looking at 20'000'000 entries into that table...
My Question is: Is this design acceptable??
Is 20 million too many entries for a MySQL Table???
And how much space will be used up by the db assumming the numbers i stated. Im going to start by running the app on a cheap webserver - with 500mb storage space.