frikus Posted March 23, 2007 Share Posted March 23, 2007 Does the quantity of columns in the MySQL table affect the search speed? The search is performed on indexed columns. Quote Link to comment Share on other sites More sharing options...
artacus Posted March 23, 2007 Share Posted March 23, 2007 No. It will slow it down returning the results if you do a select * and have a ton of columns. Quote Link to comment Share on other sites More sharing options...
frikus Posted March 24, 2007 Author Share Posted March 24, 2007 so it doesn't make sense to divide a table with lots of columns into several tables with the same primary key column if i don't do select * ? Quote Link to comment Share on other sites More sharing options...
artacus Posted March 24, 2007 Share Posted March 24, 2007 Not really... as long as its normalized. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 4, 2007 Share Posted April 4, 2007 It really depends how many we're talking about, NULL vs NOT NULL, indexes, fixed vs dynamic, etc. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.