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@[...].com>
> To: php-db@[...].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@[...].com> wrote in message
> news:652305240505281545630db82@[...]..
>  > >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
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php