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 . Quote Link to comment 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. Quote Link to comment 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.