[0] https://support.google.com/webmasters/answer/183668?hl=en
[0] https://support.google.com/webmasters/answer/183668?hl=en
My case might be unique where the site is being built at the end of a pipeline that sorts through millions of rows of data and gives you the content you want based on your filters, but it's honestly not difficult to get to 50K URLs for many sites that have some age on them.
(not indicating Aeolun specifically, just replied to the lowest level)
I run a Python script after the build has completed that reads the entire sitemap and chunks it into parts of 50k.
+1 for mentioning incremental builds as well. These two features are often overlooked and people just ask "why do you even have so many pages?" and it ends there because nobody wants to entertain the power user.
A third disadvantage I've seen is search. I use fuse to generate a JSON for client side search but it takes a lot of memory to render and is a cause for concern.
I always got the impression that they were more for small blogs/sites.
If you don't need the user roles and editor experience you get from WP then you can feed your generator the content from any source you like as long as the files have the correct frontmatter to turn them into pages/posts. You might need a little glue script here and there to chain systems together, but it's not super difficult to adapt to whatever pipeline you need after you understand where your content comes from.
Everything after the first request is cached by a CDN anyway so the only difference is when that original page is generated. It only takes a few milliseconds to generate the page from a database vs reading a file from disk.
The bigger advantage to static sites is portability (even though you can have a webapp that reads markdown files just as easily as database rows).