I have a dynamic sitemap that will change on a daily basis. Because I'm hosting on Heroku, I'm having some difficulty getting it to persist. I'm considering having the sitemap generate on request, rather than generated and saved to a static file on the server.
It's a large file with tens of thousands of entries so it takes a considerable amount of time to load. Will this affect how search engines treat my site?