Re: [PERFORM] Number of Columns and Update

2014-12-22 Thread Andrew Dunstan
On 12/22/2014 03:53 PM, Robert DiFalco wrote: This may fall into the category of over-optimization but I've become curious. I have a user table with about 14 columns that are all 1:1 data - so they can't be normalized. When I insert a row all columns need to be set. But when I update, I so

Re: [PERFORM] Number of Columns and Update

2014-12-22 Thread Heikki Linnakangas
On 12/22/2014 10:53 PM, Robert DiFalco wrote: This may fall into the category of over-optimization but I've become curious. I have a user table with about 14 columns that are all 1:1 data - so they can't be normalized. When I insert a row all columns need to be set. But when I update, I sometim

[PERFORM] Number of Columns and Update

2014-12-22 Thread Robert DiFalco
This may fall into the category of over-optimization but I've become curious. I have a user table with about 14 columns that are all 1:1 data - so they can't be normalized. When I insert a row all columns need to be set. But when I update, I sometimes only update 1-2 columns at a time. Does the n