Database Responsiveness and load times

I am curious about the difference between dynamic data queries.

“Do Search for User:Count” seems to load all the information to the client side then run the count.

“Do Search for User:Group by Country” seems to only load the tuple of the group by and the aggregate.

When loading over 1500 results the second option (Group by) loads basically instantly while the first option (Count) runs almost instantly.

Is there anyway to speed up the first result or is there a way to access the querying abilities available to the second option??