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 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. Link to comment https://forums.phpfreaks.com/topic/148703-table-index-question/#findComment-780820 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.