3 ms·
It tend to include a large proportion of the large, expensive reporting queries your business people want to do. Whether or not those kinds of queries dominates
by vidarh 5y ago
It tend to include a large proportion of the large, expensive reporting queries your business people want to do. Whether or not those kinds of queries dominates for your system will depend greatly on your system.
You also need to reach a certain scale before the choice (either way) will affect you enough to matter.
But when you reach that scale it can be the difference between reporting queries taking seconds vs. hours in some cases.
For some systems you'll end up wanting both, and stream updates from the transaction focused db (row oriented) into a separate reporting database that uses a column store.