TimeSeries group request slower than expected

[MikeNeilson]

curl -X 'GET' \
  'https://<host>/cwms-data/timeseries/group?office=NWDP&include-assigned=true&timeseries-category-like=NWP_A.%2A' \
  -H 'accept: application/json'

The returned result is rather large, but should be even then should be relatively fast given what the data is.

Tested on cwbi-test and future prod, equally slow on both.

[krowvin]

@msweier @LaurenAllin

[rma-rripken]

How big is the response in terms of mb and also how many groups/how many assignments? How slow is it to return? That end-point doesn't have paging, we could add paging.

We can also grab the query jooq is generating and see if it can be optimized. I suspect the orderBy(attribute) clause is globally ordering the results and can could be moved.