Results 1 to 7 of 7

Thread: db design

  1. #1
    Join Date
    Nov 2004
    Posts
    3

    Unanswered: db design

    Hi,
    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.

    What do you think?

    Thanks in advance,
    Hamza.

  2. #2
    Join Date
    Nov 2004
    Posts
    14
    Do you want to check the sql-statements a user has done or do you want to know the web-sites (each web-site is a test) the user has visited?

    Greetings,
    Markus

  3. #3
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up try this

    Hai,

    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,

    Userdetails
    ----------

    userid,(primary key)
    fname,
    lname,
    (any other details like email..)

    TestDetails
    -----------

    Testid,(primary key)
    testname,
    testdescription,
    (any other details for test)


    TestResults
    -----------

    resultid (primary key),
    userid,
    testid,
    status (pass or fail)
    date,


    To find out when the user took the test and to check the result of the test u can query the testresults table...

    Hope this helps...
    Sudar

    --
    My Blog

  4. #4
    Join Date
    Nov 2004
    Posts
    3
    Thanks for your reply.
    If I have for example 5000 users and 200 tests, I would have 1 000 000 entries in my table. Will this be a problem? Is that too much on MySQL?

    Thanks again,
    Hamza.

  5. #5
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up

    hai..

    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 ?
    Sudar

    --
    My Blog

  6. #6
    Join Date
    Nov 2004
    Posts
    3
    5000 users and 200 tests is the very maximum expected

    Thanks your help,
    Hamza.

  7. #7
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137
    Quote Originally Posted by hamzaf
    5000 users and 200 tests is the very maximum expected

    Thanks your help,
    Hamza.
    So no probs...Go head and implement your db in MySQL and i am sure MySQL will be happy to give u the performance that u need
    Sudar

    --
    My Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •