"Assistant" page is taking too long to start loading

img: https://www.ankurprem.com.br/wp-content/uploads/Untitled-1.jpg

Just as a bench mark for you… I don’t have any exotic amount of files.

Theme 2014, WP 4.2 and other site 4.3
Total images 370 approx on both
I’m on an el’cheapo but reliable shared hosting company.

Load time is 15 to 20 seconds.

As always backup your database and file structure…
But then maybe run a database Optimizer…
good luck and hope it works out.

@robswaimea,

Thanks for adding your benchmark to this topic!

@ankur,

Thanks for your report and for posting the link to your screenshot. You wrote “after I deactivated/activated the plugin. Does that mean that the page load performance was better before you did that? Was this part of an upgrade or other maintenance activity on the site?

The deactivation/activation shouldn’t have any effect (that I can think of) on the page load behavior. None of the other plugins you listed have caused problems that I know of; I use WPML on my test system.

The first thing I would suggest is to disable the “where-used” reporting options. They can be database intensive and unless you need the information you won’t miss them.

Go to the Settings/Media Library Assistant General tab and scroll down to the “Where-used database access tuning” section. Set one or all of the four options there to “Disabled”. The two “Gallery in” options are the most intensive; you can try disabling them first.

If that doesn’t resolve the problem, let me know. I am happy to investigate further and I am always interested in improving the performance of the plugin. I will leave this topic unresolved until I hear back from you. Thanks again for the report and for your interest in the plugin.

I also have this problem
But I ran into this problem a few days
Has no relevance to deactivated/activated the plugin

Hello David and other friends.

This steps really helped… the loading time jumped from minutes to 8-10 seconds. Other pages starts to load almost instantly, no more than 3 seconds. But now the Assistant page is usable, differently than was before (taking so much time to load). Even to [bulk]edit items the “delay” was happening – actually every step done in the Assist page.

I deactivated the plugin ’cause I’m having an issue (totally unrelated with this behavior) in WPML, so I wanted to see if was any plugin compatibility issue (which was not). I reactivated it like 2 minutes after.

Strange that everything was 100% normal before, and I just noticed this yesterday (after the [de]activation – but I really don’t know if this have anything to do with the matter).

But now,

Thanks to all for their posts and updates.

It looks like disabling the where-used reporting solves this problem, so I am marking the topic resolved. Please update the topic if you have any additional problems or questions.

The “Featured in” and “Inserted in” reporting does not often cause performance problems, but the “Gallery in” and “MLA Gallery in” reporting does a lot of database processing and can be very slow. The “cached” settings can help, but unless you need the information the disabled setting is best.

You can also improve performance by limiting the number of items shown on each Media/Assistant submenu page.

You can find some additional information in this earlier topic:

Heavy SQL request loads

Thanks again for working with me on this issue and for your interest in the plugin.