Broken uncategorized folder for large media libraries

  • Resolved Rodrigo Arias

    (@kreppar)


    4 years, 11 months ago

    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

    https://cln.sh/lBSwBb

    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.

    • This topic was modified 4 years, 11 months ago by Rodrigo Arias.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘Broken uncategorized folder for large media libraries’ is closed to new replies.