Performance [message #39510] |
Sun, 21 July 2002 18:23 |
Jamie Mack
Messages: 8 Registered: January 2002
|
Junior Member |
|
|
Hey there,
This is a question with regards to optimization of tables. I am currently adding some new functionallity to a system and I have to choices.
a) Add 45 new fields to a table that already has 108 columns! that is a total of 153 columns.
b) Add a new table with the 45 columns (plus the ID from the other table) so that would have 46 coloumns.
I would prefer to do option a as option b is going to cause a mutant (mutating table) and that means i have to write more code. So the Question is... Is it alright from a performance view if you have a table with 153 columns.
Thanks in advance
Cheers,
Jamie Mack
|
|
|
Re: Performance [message #39524 is a reply to message #39510] |
Mon, 22 July 2002 09:13 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
If those 45 new columns would truly be attributes of the primary key of that table, then I would add them to the existing table rather than create a new table and have to deal with all of the linking and referential issues, plus the additional join on every query.
|
|
|