Support » Plugin: All in One SEO Pack » slow query on shop with thousands of users

  • Resolved Edith

    (@terragirl)


    I’m running a large shop with around 12000 registered customers and we’re investigating slow db performance. We’ve installed “query monitor” and one of the slow queries is linked to your plugin.

    Screenshot: https://www.dropbox.com/s/5jndd0y4k8y28eg/Bildschirmfoto%202019-09-26%20um%2013.13.31.png?dl=0

    Query is in
    wp-content/plugins/all-in-one-seo-pack/aioseop_class.php:1093

    		$user_args = array(
    			'role__in' => array(
    				'administrator',
    				'editor',
    				'author',
    			),
    			'orderby'  => 'nicename',
    		);
    		$users = get_users( $user_args );

    Is there any way to optimise this query to run more efficiently on a large shop? NB: we’re currently using the free version, if the PRO offers faster queries please advise.

    Many thanks, Edith

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.