Re: How many rows for 100 questions?

indexes should, on average, be applied to any column(s) that are in a where clause, multi-column indexes are acceptable bastien

From: "...helmut" <forum@helmutgranda.com> To: php-db@lists.php.net Subject: Re: [PHP-DB] How many rows for 100 questions? Date: Tue, 31 May 2005 15:38:31 -0500 THank you for ya'lls feedback, one more question in regards to ID's, Primary Keys and indexing. Lets say that in the future the admin wants to list all the records for answer 50, now, if I have my user ID as the primary key, do I have to index all my answers so they are easy to search? or it doesnt really matter? Thanks! -- ...helmut helmutgranda.com ""Andrés G. Montañez"" <andresmontanez@gmail.com> wrote in message news:652305240505281545630db82@mail.gmail.com...

I have a questionary that has 100 questions, Should I create 2 tables 1 with the user information and the second one with the 100 questions? What is your recommendation?

I recommend you the next table configuration: 1 table for users 1 table for the questions (so you can have more than 100) IF the User can Input the Answer -> 1 table with User ID, Questin ID and the Answer IF the User only selects a pre-defined Answer -> 1 table Answer ID, Questin ID, Answer 1 table User ID, Questin ID, Answer ID IF the User can select a pre-defined answer OR input, a MIX of both solutions. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php