5 ms·
It's not the rows that kill you. It's the columns.
by PTOB 5y ago
It's not the rows that kill you. It's the columns.
- Guest42 5y agoTrue, and improper indexing.
- at_compile_time 5y agoWhy is that?
- bigiain 5y agoRows with an integer id and a few integer or bit flag columns or maybe a short short fixed width char column or two and a few well though out indexes, is a way different beast compared to something with dozens of big varchar() or blob columns (or worse still, json or xml text columns with un-indexable key/values inside that you need to parse out before you can run selects on them...)
- at_compile_time 5y agoAh, I think I understand now. It's not the amount of data (rows), it's how that data is structured (columns). I thought you were saying that number of columns was more important than number of rows, which clashed with my naive intuition.
- zozbot234 5y agoModern RDBMS's can support JSON and XML as native data types, i.e. you absolutely can index within them and they have facilities to speed up the parsing.
- bigiain 5y agoYeah. But not if you've just shoved them into text columns.