Orderlist from management API is too large

[skttl]

Which component is this issue related to?

Umbraco Commerce (Core)

Which Umbraco Commerce version are you using? (Please write the exact version, example: 10.1.0)

16.2.2

Bug summary

I appreciate this is probably not a bug per se. But we are in the middle of upgrading an existing v13 to v16, and the loading time of the order list has gotten slower.

This is because the API now loads 100 orders per page in stead of 30. We have quite a lot of data in custom properties, so the API response is nearly 4MB (I know, we should fix this too - but for now we need to get the client happy at 16 before we can do anything about that :))

Have I missed a configuration setting somewhere, or is it intended that the orderlist should load that many orders per page?

Specifics

No response

Steps to reproduce

Open the order list in the backoffice.

Expected result / actual result

Expected to not load 100 orders per page.

Dependencies

No response

---

This item has been added to our backlog AB#56826

[mattbrailsford]

So I think at a minimum we could reduce this to say 50, but we can also take a look at whether we can implement a page size option. We used to have a dropdown where you could select your page size but I think it was dropped due to the CMS table view not having it, but I think we could add it ourselves.

[mattbrailsford]

I've uploaded a 16.3.1--preview.6 build to our nightly feed which now includes a page size filter option next to the pagination controls. This is available for carts, orders and gift cards. This defaults to 25 for each of these.

The value isn't yet persisted so it will always reset to 25 if you navigate away, but given the page number also doesn't persist I don't think that is essential for your issue. I will create a future backlog item though to look at persisting the pagination state.

If you'd like to give this a try and see if this helps with your page load speeds?