Queries still slow

Well, I ended up removing the plugin and making a small plugin that blocks this slow query with the users_pre_query filter, and also I hid the quick edit link, since it does not work correctly without the query.

Hello, thanks for your report of poor performance.

The queries you showed are indeed the ones generated by my plugin to populate the post and page author dropdown lists.

Have you tried also using the Index WP MySQL For Speed plugin? That may give you performance improvements. If you can install a persistent object cache, that will help too, not only for this plugin’s performance.

Question for you: How many of your users are administrators / editors / authors / contributors (that is, how many can appear in your author dropdown lists)? When the plugin sees fewer than 200 of those users, it uses a cache rather than the queries you showed. I chose “200” arbitarily, and I can make that number larger in a new release if it will help.

• This reply was modified 2 years, 5 months ago by OllieJones.

Hi, thanks for the reply.
I haven’t tried your other plugin, I haven’t used persistent object cache (I prefer to avoid it, could cause problems). Only a few users are roles that can post (like 4 or something).

Thank you for your patience. In version 1.0.2 I have added some features intended to help your problem.

(And, for what it’s worth the WordPress core performance team *strongly* recommends the use of a persistent object cache on large sites.)

Thank you for your work. I don’t plan on spending more time testing on this problem for now, but I will keep it in mind.

Version 1.1.1 uses faster database queries. It should resolve some performance problems.