Subject Re: split or not split a table with long rows ?
Author nathanelrick
Thanks Dmitry,

> Memory is cheap, just buy it.

i was speaking of more than 128GB of memory :)

> About splitting table I have an opinion:
> if some rows are being accessed more than other, than split table.
> This will
> - make row size less for most reading rows
> - make less pages for most reading data

you mean if some query need often for exemple fieldA, fieldB but rarely we ask for fieldz and feldw then it's better to split the table and in this way the select fieldA, fieldB from table1 will be more faster than the select fieldA, fieldB from AllFieldtable ...
(and that was my suprise to discover it (see my past thread) as i was thinking than when we access a row via index, the row length is not very matter)

hmmm need to try ... if the speed we win in some query will be not lost in the join we need to do in other ... also i discover than using pooling of prepared query can speed (a lot) so yes need to try... but my first opinion is to join the table