As long as your database is normalised then it should be okay. Andy
>From: "J Siegel" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: [php_mysql] mysql record size efficiency... >Date: Wed, 08 Mar 2006 15:52:49 -0000 > >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. _________________________________________________________________ Free blogging with MSN Spaces http://spaces.msn.com/?mkt=nl-be 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/
