Still struggling: Laravel dynamic sitemap generation issues, help!

Okay, I'm seriously pulling my hair out here. Following up on my previous post about Laravel technical SEO sitemap challenges – I'm still completely stuck and honestly, it's becoming a huge bottleneck for our site's visibility.

I've spent countless hours trying to implement a reliable dynamic sitemap for our e-commerce platform. We're talking thousands of product pages, and they're updated constantly. I've tried different packages, custom scripts, even tried breaking it into multiple sitemap index files, but I keep running into issues. Either it's memory limits when generating, or it's timeouts, or Google Search Console just isn't picking up all the URLs, especially the newer ones. It feels like every solution I try just creates another problem, and I'm desperate to get this right so our crawl budget isn't completely wasted.

What's the absolute best practice or most robust approach for generating and maintaining a truly scalable Laravel sitemap for a large, frequently updated product catalog? Are there specific strategies or packages that handle memory and performance well for such scenarios? I need a solution that just *works* without constant babysitting. Thanks in advance!