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. Link to comment https://forums.phpfreaks.com/topic/44009-does-the-quantity-of-columns-in-the-mysql-table-affect-the-search-speed/ 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. Link to comment https://forums.phpfreaks.com/topic/44009-does-the-quantity-of-columns-in-the-mysql-table-affect-the-search-speed/#findComment-213862 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 * ? Link to comment https://forums.phpfreaks.com/topic/44009-does-the-quantity-of-columns-in-the-mysql-table-affect-the-search-speed/#findComment-213975 Share on other sites More sharing options...
artacus Posted March 24, 2007 Share Posted March 24, 2007 Not really... as long as its normalized. Link to comment https://forums.phpfreaks.com/topic/44009-does-the-quantity-of-columns-in-the-mysql-table-affect-the-search-speed/#findComment-214004 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. Link to comment https://forums.phpfreaks.com/topic/44009-does-the-quantity-of-columns-in-the-mysql-table-affect-the-search-speed/#findComment-221135 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.