Improve performance of Sitemap.xml generation

nopCommerce version: 4.60

I find us continuously encountering an issue related to the generation of the sitemap.xml file when dealing with substantial product catalogs, in the scale of hundreds of thousands of products.

At present, the solution seems to be to write custom code or use a distinct service to generate the sitemap.xml for such large-scale catalogs. This isn't the most efficient solution and it would be extremely beneficial if the system could handle it more seamlessly.

Would it be possible to enhance this feature in the upcoming releases of nopCommerce? It would greatly improve our workflow and benefit other users with large catalogs as well.

Source: https://www.nopcommerce.com/boards/topic/97598/request-for-sitemapxml-generation-improvement-in-future-nopcommerce-version