Subject | fields count + performance |
---|---|
Author | martinthrelly |
Post date | 2008-08-18T04:07:07Z |
hello. if i have a table with lots of fields (e.g. 100 varchar(255),
100 decimal, 100 int, 100 smallint, 100 datetime, 10 blob) will this
make the performance very slow when selecting and inserting data etc.
as a bit of background to this, previously we had a EAV style
architecture for storing user defined field data. now we are looking
at more search friendly structures as we look to implement searches
and paging into our app.
thanks
100 decimal, 100 int, 100 smallint, 100 datetime, 10 blob) will this
make the performance very slow when selecting and inserting data etc.
as a bit of background to this, previously we had a EAV style
architecture for storing user defined field data. now we are looking
at more search friendly structures as we look to implement searches
and paging into our app.
thanks