Sitemap files are limited to 50K URLs each.
The next release of the sitemap-module will support the creation of sitemap index. But the feature of autosplit by number limit is not implemented yet, but it in the short term roadmap (release >=2.1)
You have to use the routes option with a function that will fetch your data from your database.
which database do you use?