I have a large table, about 750M rows.
I have an application using
Entity Framework to load and parse data, a query that returns 2 million rows takes 4 seconds.
The same exact query takes 8 seconds using
SQL Server Management Studio.
I noticed this happens with other queries (that all returns large data sets).
Both of the connection are using
When including client statistics, I see this line (no idea what it means):
Client processing time 2539 2539.0000
Why would a
SSMS query be slower ?