>From: "Andrew Kuebler" <[EMAIL PROTECTED]> > >2) Is it just as fast with Mysql to access 10 fields in a table with 10 >columns as it would be to access those same 10 fields among let's say 90 >other fields in a 100 column table?
Are you certain that performance should be your primary concern here? I prefer to design databases with separate tables of tightly coupled information, then LEFT JOIN them as needed. This makes maintenance much easier, and may also be a performance plus, due to locality of reference issues. Only when I'm certain that this form (4NF? I forget) is negatively impacting performance do I bother optimizing to 3NF by permanently joining tables. ---- SQL SQL SQL SQL SQL SQL SQL SQL ---- -- : Jan Steinman -- nature photography: <http://www.Bytesmiths.com> : Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services> : Join the forums at <http://www.Bytesmiths.com/wiki> --------------------------------------------------------------------- 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
