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? Quote 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. Quote 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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.