In message <[EMAIL PROTECTED]>, wrwatson2003 <[EMAIL PROTECTED]> writes >I do know for a fact that there will be over 10,000 records put into >the database immediately once the project is finished.
There will be about 90 fields, one for each checkbox. Each field will be quite small - assuming that you are using MySQL, they will be probably be TinyInts, so won't take a lot of space. > I don't think >having 900,000 fields to filter through in one table is a good idea! I can't figure out what you mean here... >I was told by an MCSD that the more tables I have, the better. No, because YOU will have to open 4 tables instead of opening one! >I'm not really sure why I thought I would need 4 tables. I'm looking >for a way to minimize the number of fields my queries have to search >to retrieve data. You have actually made it more complicated, because now you have the same number of fields, but spread across 4 tables. >Can you help me? What do you suggest I do? Create 1 table! If you really need to, create a field "oldtablenumber" which will show which table the records "used" to be in, just to keep your head together. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
