For large journals (several 1000 articles), the dynamic creation of the sitemap takes too long. Google Search Console can deal with that, but not Bing Webmaster Tools, which alway run into a timeout.
Is there a way to increase the speed of sitemap creation? Database caching? Redesigning the algorithm so that a sitemap index file and partial sitemaps are created?
Of course the sitemap can be stored in the file system, but then it is static.
Application Version - e.g., OJS 3.3.0-8.
Example: https://www.chimia.ch/chimia/sitemap
(compare load time to static sitemap https://www.chimia.ch/sitemap.xml)
It won’t get better - this journal publishes about 200 articles annually, and it is also planned to add all the back content back to volume 1.
Last resort would be to create a cron job with a curl or a wget that saves the sitemap periodically.