I've been experimenting with mysql/php with little databases and 
trivial tests.  I'm now ready to move to my real project.  It involves 
tables with more than 100 fields.  There will be about 50,000 of these 
records.  Before I start writing all of the code to handle this, I'm 
wondering about efficiency...

Would it be better to break these large records into smaller ones 
spanning multiple tables?  It is more efficient for storage or 
searching if the records are single-large ones or smaller-multiple-
small ones?

Are there any guidelines about this or anything else I should be 
considering?

Any references to discussions about this type of thing?

Thank you very much for any help.








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/
 


Reply via email to