I'm currently developing a website where each registered user has to pass some tests.
I want to track each user's progress:
That is, for each user I want to know which tests he passed, when he passed them, after how many failures, etc...
I'm using a MySQL database, and I'm wondering where I could store all these user info.
You can store the user details in a seperate table called users where each user will have a unique userid (primary key),
then store all the details abt the test in a seperate table, and the test results in a seperate table,
The following is a rough schema,
(any other details like email..)
(any other details for test)
resultid (primary key),
status (pass or fail)
To find out when the user took the test and to check the result of the test u can query the testresults table...
I have used mysql with well over 2000000 and have not got any adverse performance problems. So i hope 1000000 will not create any problems for u.
By the way is 5000 users and 200 tests is the maximum count expected or is the minimum count expected ?