Performance impact of large number of columns

I have a table in a stock analysis database that has 284 columns. All columns are int, double, or datetime, except the primary key (varchar(12)). By my calculation this makes each row 1779 bytes. CREATE TABLE technicals ( symbol varchar(12) primary key, last double, open double, high dou

Re: Performance impact of large number of columns

, YMMV depending on your database engine, schema, indexing > efficiency, etc > > Howard Hart > Ooma > > Jeremy Jongsma wrote: > > I have a table in a stock analysis database that has 284 columns. All > > columns are int, double, or datetime, except the primary ke