How to create a large sitemap?

Question

Create a sitemap

Hello!
There is a site with ~30,000,000 pages. The sitemap is generated by a PHP script in... quite a long amount of time. The data for the sitemap is taken from the MySQL database. Tell me which programming language is better to use so as not to create a large load on the server (the sitemap will be updated daily).

Answer 1

It makes no sense to shove 30 million pages into one file. Yandex, for example, insists that there should be no more than 50 thousand links in one map file.
Try splitting the map into several files
https://www.sitemaps.org/ru/protocol.html#index
then update the next piece of the map every two minutes by the crown, the whole map will be updated in a day, and then in a circle.