caedas Posted April 26, 2008 Share Posted April 26, 2008 Hiya all! I am working on the construction of my database right now, and it popped in my head to find out a question I have previously had. Is it more efficient/better practice/whatever...to have multiple tables with each table having less columns (i.e. table 1 assigns an id and name...table to uses that id and has a few other columns.)... Or...is it better to use less tables and use more columns...like having a products table with auto-incremented ID, name, price, serial number, blah blah blah... I really am not sure which way to develop my database because of this...Even if the difference is barely noticeable, I would still do the better one (while I wouldn't if it, for the most part, doesn't matter.) I really appreciate the wisdom you guys hopefully will share with me . Link to comment https://forums.phpfreaks.com/topic/102975-question-on-structure-of-database/ Share on other sites More sharing options...
yzerman Posted April 26, 2008 Share Posted April 26, 2008 That depends on exactly how you are going to be pulling or storing your data overall. If you are not going to call a set of fields all of the time, then it is better if those fields were in a separate table. Link to comment https://forums.phpfreaks.com/topic/102975-question-on-structure-of-database/#findComment-527521 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.