3 ms·
Fair. 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
by greggyb 7y ago
Fair. 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.