Hi, I got a table with standard userdata (email, address). I want to be able to provide additional fields (like age, gender etc). Generally I have about 8 standard fields and up to 30 optional fields which may vary. Say something like this:
Customer A wants its users to provide email, address and gender. Customer B email, address, age, shopping-preferences. Now Customer A has a million users and Customer B 2 million. And there will be a Customer C..<something> too :) I wonder what would be the best way to achieve this. I will have to handle a huge number of users in that table. My first guess would be to create a table with 40 columns where most columns are most of the time empty. Does this have an impact on the performance? I cannot predict which customer will use which fields since they should be totally free in their selection. I cannot predict the number of customers either. Is using a single table the best choice? (I know we learned not to do so at university - but hey, this is real life... :) Thanks, Peter magic words: sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
