Broken uncategorized folder for large media libraries
-
Hi, thanks for your work on this plugin.
I have used it for a little over a year without major problems, but here I found one.
One of my projects has more files than usual, about 10k and I have noticed that the uncategorized folder stops displaying files when the other categories include enough files.
I am hosted in WP Engine and the reason is the SQL query of the Uncategorized folder includes all the Post IDs of the other folders in a post__not_in clause
WP Engine throws a KILLED QUERY error but I think it would be similar in other hosting.
I wonder if it would make a difference instead of taking the IDs and including them in post__not_in or post__in clauses, send the JOIN for MySQL to resolve internally and thus simplify the AJAX request.
- You must be logged in to reply to this topic.