racer x Posted March 10, 2009 Share Posted March 10, 2009 Hi, noob question here... I am wondering when it is best to create an INDEX for one large table OR to create many separate tables for the same data. For example: If you had 200 vendors for 10 different categories, would you: a.) Create 10 tables(for categories) with each table containing 200 vendors. OR b.) Make one table with all 2000 vendors and then specify an index. Is one method faster than the other?(talking search speed, not creation speed) Thanks Quote Link to comment https://forums.phpfreaks.com/topic/148703-table-index-question/ Share on other sites More sharing options...
redarrow Posted March 10, 2009 Share Posted March 10, 2009 I would show the vendors, then the category that vendor got. Speed don't see no difference in both ways tell the truth. Quote Link to comment https://forums.phpfreaks.com/topic/148703-table-index-question/#findComment-780820 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.