3 ms·
I haven’t used the columnstore in production and can’t vouch for it either. It makes sense that k-ordered write performance on column-oriented data would suffer
by guscost 7y ago
I haven’t used the columnstore in production and can’t vouch for it either. It makes sense that k-ordered write performance on column-oriented data would suffer, do you know of a good benchmark measuring this?
Also I don’t like the phrase “true real time applications” at all. It is less useful than even Microsoft’s OLAP-Cube-ETL-OLTP word salad, and embedded developers in particular are going to be cringing if they read that.
- greggyb 7y agoFair. I use it as a shorthand for reporting scenarios with required data latency measured less than a second from transaction to reporting tier. Yes, there's an entire world of performance below 1 second, but it's a useful threshold. When I've been benchmarking SQL Server for such use cases, we've always found its columnar indices to be too much overhead.