Jump to content


This topic is now archived and is closed to further replies.


MySQL load concerns

Recommended Posts

Would I be going to far with a plan like this:

My teacher is having me make a site for him to post notes/quizzes/such for AP students, he plans to make a little extra cash using Google Ads; however, with all the traffic he wants, I'm confused as to how efficient my current idea for quizzes is. Here's the quiz mysql table:
[code]CREATE TABLE `' . FT_MYSQL_PREFIX . 'quiz`
                            id int (5) NOT NULL auto_increment,
                            title varchar(100) NOT NULL,
                            question_first_id INT(6) NOT NULL,
                            question_last_id INT(6) NOT NULL,
                            question_list text NOT NULL,
                            PRIMARY KEY (id)

And here's the question table:
[code]CREATE TABLE `' . FT_MYSQL_PREFIX . 'quiz_question`
                            `id` INT(5) NOT NULL auto_increment,
                            `question` TEXT NOT NULL,
                            PRIMARY KEY (`id`)

Basically when you create a quiz, it batch adds all the quiz questions to the quiz question table, so you can add each individual question to a 'favorites' list to help you study later. The Quiz table stores a reference from the first question it added to the last, so it can still generate the same quiz.

Is this a decent way to go about it? Any general suggestions about MySQL speed I may be missing?

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.