total noob here, how to fix 'too many URLs' error with dynamic XML sitemap in Laravel SEO?

hey everyone, total noob here with a question about sitemaps and Laravel SEO. i'm trying to get my head around generating a proper dynamic XML sitemap for my new Laravel project.

the app has a ton of user-generated content, so i really need an auto-updating and future-proof sitemap. i've been looking at solutions like 'Dynamic XML Sitemap for Laravel & All Websites (Auto-Updating & Future-Proof)' but running into issues.

• The Problem: when i try to generate the sitemap, especially with a lot of entries (we're talking tens of thousands already), i keep hitting a 'too many URLs' error or memory limits. it seems like my current approach just can't handle the scale.
• What I've Tried So Far:
  • i initially tried a popular Laravel sitemap package, but it chokes on the number of records.
  • i also attempted to manually chunk the sitemap into multiple files, but then google search console complains about index sitemaps being too complex or not finding all sub-sitemaps.
  • i even looked into directly querying the database and trying to stream the XML, but that felt way over my head and still ran into memory problems.
• My Goal: i need a robust solution that can dynamically generate and update the sitemap for millions of URLs without breaking. ideally, something that works seamlessly with Laravel and keeps my Laravel SEO in check.
• Specific Question: for those of you who have experience with 'Dynamic XML Sitemap for Laravel & All Websites (Auto-Updating & Future-Proof)' or similar solutions for high-scale Laravel apps, what's the best way to handle the 'too many URLs' issue? is there a specific configuration or a pattern i should be following?

any advice would be super appreciated, i'm really stuck here. help a brother out please...