I have a client that I did an import for, and I'm currently rebuilding the search index.
When it hit the Media Gallery comments portion (xf_mg_comment table), it was fairly quick at first but has been getting slower as it goes.
There are 1.8 million comments, and its currently on comment number...
Depending on what's in the Takeout archive, I might already have code that can import it, or be easily adapted to. If you're interested, let me know and I'll send a private message.
While database engine independence is good, my concern is PDO tends to benchmark about 5% to 6% slower with prepared statements using MySQL. I'd be interested in seeing how this translates to real world impact on Xenforo.
The downloads are available from within the forum's admin panel. So long as a person has a super admin login, they can keep it updated without needing to log into the customer account. Its been this way for years.
In the big picture, I don't think was a large number or extensive outage. The reports I saw were of dozens of large sites impacted, nothing indicating large chunks of their network or widespread outages. Overall outage reports are about 5% of the size of the big outage in November.
I'm not...
It seems you're not a car guy (or many other hands on hobbies for that matter), or your idea of car guy is you can change spark plugs and oil.
Car manufacturers do not publish the books on the Internet that service technicians use. Why would they, when they license them to dealers and techs...
Why? Because AI is only as good as the data fed to it, and new issues, ideas, products, etc. can only be answered by humans who bring the new knowledge to the table. If a new model car comes out, and someone needs a repair procedure, how does AI know that?