bamfon Posted February 14, 2011 Share Posted February 14, 2011 I was wondering for my new site i am making, If i have 150,000 - 200,000 rows on a table would it be a good idea to make 2tables? and what way would be faster when finding a row id having 1 table or having to tables half the rows in each and using join and how long would it take to load? Link to comment https://forums.phpfreaks.com/topic/227587-sql-and-tables-speed-question/ Share on other sites More sharing options...
fenway Posted February 14, 2011 Share Posted February 14, 2011 200K rows is nothing -- leave it be. Link to comment https://forums.phpfreaks.com/topic/227587-sql-and-tables-speed-question/#findComment-1173890 Share on other sites More sharing options...
bamfon Posted February 14, 2011 Author Share Posted February 14, 2011 lol thank you one last question before i marked as solved, how many rows would count as something? Link to comment https://forums.phpfreaks.com/topic/227587-sql-and-tables-speed-question/#findComment-1173894 Share on other sites More sharing options...
fenway Posted February 16, 2011 Share Posted February 16, 2011 Tens of millions. Link to comment https://forums.phpfreaks.com/topic/227587-sql-and-tables-speed-question/#findComment-1175019 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.