Just in case anyone is interested, I've worked for several months on a custom .NET TDS listening solution for several different things I've been making.
https://reddit.com/link/1xtwlti/video/hnjsyd8he21i1/player
Works best for ODS / Reporting environments where tables aren't frequently updated.
Your SQL Server Client App > Cache-Engine-TDS-1433 > SQL Server-TDS-1433
Here are some of my test results:
Query At SQL Server From the cache
10 rows from 30M fact rows 7.7 s, 7.6 s 0.02 s
a parameterised query ( sp_executesql ) 3.5 s, 3.6 s 0.01 s
500,000 rows 10.1 s, 10.2 s 1.3 s
medians over 30M rows 77.8 s, 93.1 s 0.01 s
the same 10 rows, tracked mode, Change Tracking checked first 7.7 s 0.03 s
mechanics:
Run 1 a query takes 40 s β SQL Server answers. DaffyZoom notes it: slow, and safe to cache. Run 2 the same query β SQL Server answers again; DaffyZoom keeps an encrypted copy. Run 3 the same query β Instant answer. Run 500 the same query β Instant answer.β¦