1. If i have the following code within app/product/sitemap.js , does this mean every time someone loads this subdomain (www.domain.com/products) the script run? If so how can I prevent this, I just want to create this sitemap to update google crawlers once in a while. I don't want to make unsessery reqeusts to my db

import { BASE_URL } from '@/app/lib/constants'
 
export async function generateSitemaps() {
  // Fetch the total number of products and calculate the number of sitemaps needed
  return [{ id: 0 }, { id: 1 }, { id: 2 }, { id: 3 }]
}
 
export default async function sitemap({ id }) {
  // Google's limit is 50,000 URLs per sitemap
  const start = id * 50000
  const end = start + 50000
  const products = await getProducts(
    `SELECT id, date FROM products WHERE id BETWEEN ${start} AND ${end}`
  )
  return products.map((product) => ({
    url: `${BASE_URL}/product/${id}`,
    lastModified: product.date,
  }))
}

2. My root sitemap and robots.txt look like this. Will the products sitemap be crawled automatically or do i need to specifically point to it?

export default function sitemap() {
    return [
      {
        url: 'https://domain.com/products',
        lastModified: new Date(),
        changeFrequency: 'monthly',
        priority: 1,
      },
...
]

User-Agent: *
Disallow: /admin
Disallow: /api/*


Sitemap: https://domain.com/sitemap.xml