How can I improve sitemap generation speed in a Hydrogen storefront?

[0xdhrv]

hello, has anyone tried using the default `sitemap.xml` file from the hydrogen storefront, I am using Oxygen deployment, and we are hitting `SUB_REQUEST` limit of Workers also, the sitemap generation is very slow. I am paginating the results with the graphql API and the suggested pagination approach.

- https://github.com/Shopify/hydrogen/blob/2023-04/templates/demo-store/app/routes/%5Bsitemap.xml%5D.t...
- https://shopify.dev/docs/custom-storefronts/hydrogen/seo
- https://shopify.dev/docs/api/usage/pagination-graphql

wondering how this can be improved?