Subject fields count + performance
Author martinthrelly
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