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