Sitemap pagination not working

Problem/Motivation

Thanks for the great module!

In my Drupal site (version 10.3.10), Simple XML Sitemap gives me 6508 "Link counts" of the type "Default hreflang".

Originally, in "Settings", I had "Maximum links in a sitemap" set to 2000 (this is the value from where I started managing the site), but I also tried to change it to 1000, 500, and 250.

Before today, I never really tried to reach the sitemap page so I can't tell you when the issue started...

In any case, independent of the number of "Maximum links in a sitemap", when trying to open any sitemap URL (?page=X), it crashs with timeout error: ERR_CONNECTION_TIMED_OUT.

On a side note, I was able to gather the sitemap records by downloading a CSV of the "simple_sitemap" table directly from the database. I can confirm that the XML itself is properly formed.

Also, looking at drupal watchdog, I see no error messages.

As of now, as long as I don't break it per page, I can see the sitemap, i.e., by leaving "Maximum link in a sitemap" blank, I have no timeout error when opening the sitemap in a browser.

Just thought I should share this with the developers, in case other experience the same issue.

Steps to reproduce

1. Have a site,
2. have about the same number of "link count",
3. set the sitemap to be broken into pages,
4. try to open the pages (for me they crashed with ERR_CONNECTION_TIME_OUT)
5. change settings so sitemap is a single file
6. try to open the sitemap (/sitemap.xml) and it will open successfully