aliento Posted September 2, 2011 Share Posted September 2, 2011 Hello , I want to know which is smartest. I have 3 tables. table_name1 - id , name , class table_name2 - id , name , class table_name3 - id , name , class Is it smart to make them all one table with an extra field? like table - id , name , class , refers_to Those tables i want to merge will have large number of entries. Thank you Link to comment https://forums.phpfreaks.com/topic/246281-i-need-a-mysql-structure-advise/ Share on other sites More sharing options...
Zephni Posted September 2, 2011 Share Posted September 2, 2011 I would say have it all in one table, I like everything in it's right place, but this also may depend on weather you know there will ONLY be 3 seperate tables, or weather you may at some point need to add more. I personaly would say it is good practise to keep it all in one table, who cares how many results are in a table, thats what they are for. Link to comment https://forums.phpfreaks.com/topic/246281-i-need-a-mysql-structure-advise/#findComment-1264751 Share on other sites More sharing options...
AyKay47 Posted September 2, 2011 Share Posted September 2, 2011 one table, will save you time and memory in the long run.. I would always try to have as few tables as possible in your database.. Link to comment https://forums.phpfreaks.com/topic/246281-i-need-a-mysql-structure-advise/#findComment-1264753 Share on other sites More sharing options...
aliento Posted September 2, 2011 Author Share Posted September 2, 2011 Ok, thank you both Link to comment https://forums.phpfreaks.com/topic/246281-i-need-a-mysql-structure-advise/#findComment-1264754 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.