Hi all

I'm considering a project which looks like it could have over a million records in a database.

Basically it consists of a questionnaire of approx. 400 questions. One table will be used to store the answers (CustID, QuestID, Answer, etc.) so that the answers can be processed easily. Therefore, every customer will generate 400 records. This will soon add up to a huge database.

Can someone tell me if MySQL and PHP4 can handle this? And what the likely performance will be and whether I would be better to have a table with 400 fields and use one record per customer.

I would prefer to have a simple table structure and 400 records as this will allow the easy modifying of the questions in the future.

Many thanks in anticipation,

Jon

Edited by - jstanton on 21 Jun 2004 15:40:04