'Count In' within post_parent() load issues
|Reported by:||anointed||Owned by:|
Using the bbPress converter (bbconverter.com) with Alex, we noticed that while trying to import large databases into bbPress that the importer kept crashing.
After a ton of tracking down the issue, it looks like Alex narrowed it down to the "Count In" portion of the post_parent() function. It seems that the post_parent can potentially have tons of "IN" causing this to be a very slow query.
As an example, when using the importer, if we disable bbPress first, then importing 500k posts takes about an hour, although all the data is input, it does not work though.
Turning on bbPress which activates the function in the plugin will cause the same import to take approx 2 weeks. (multiple tests run on this).
I do not personally have the expertise to fix the function, but it is an absolute showstopper for us trying to import huge external forums.
Hope the report helps.
Change History (7)
- Keywords reporter-feedback added
- Milestone changed from 2.2 to Future Release