I have a slow running query that I've been working on optimising.
When looking at the Client Statistics in Management Studio it was taking about 8 seconds wait time on server replies and about 1 second on Client processing time.
I have always thought that the Wait time on server replies was the number to work on and Client processing time was generally bandwidth or large data size related.
I have made a number of changes to the query and now my Wait time on server replies is around 250ms, however, the Client processing time has increased to about 9 seconds making the Total execution time slightly slower.
The result set being returned is exactly the same.
Can someone shed any light on what exactly the difference between these two numbers is and what would cause such a result?