My client has a blog app with a few thousands of posts. Because of that, the server side rendered sitemap is taking too long to render. I found this page https://nextjs.org/docs/app/api-reference/file-conventions/metadata/sitemap in the docs and did a quick test and it works. Since this is a statically generated file, I'm querying the data from our Sanity database and the posts list is server side rendered I would like to revalidate this sitemap file every ~2 hours. Does anyone know if that's possible?

(I'm not using the nextjs fetch, but the cms client lib instead since I need to use it's own query language - it's a sanity CMS).