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/