From: Jan Steinman Date: October 16 2002 8:04pm Subject: Re: How many columns does MySQL Support? List-Archive: http://lists.mysql.com/mysql/122422 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >From: "Andrew Kuebler" > >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: : Bytesmiths -- artists' services: : Join the forums at