In reply to Thierry Muller.

@Thierry - Yes, we cache the generated sitemap data in options. We store about 200 sitemap items in each option. On a front end request, the only database queries are retrieving the relevant options.

We'd love to offer any help we can. Excited for the upcoming channel :) Thanks for moving this forward in core!