Slow sql query in function

  • Hello.

    We have a store on vokomercer, there is also a responsive-lightbox plug-in, and in the latest updates, the plugin started to do a huge load on the bd, creating heavy queries.

    file:/plugins/responsive-lightbox/includes/class-galleries.php:get_users

    Could you, in the next release, change this method to use the native sql query, without using the wordpress function of get_users:

    $users = get_users(
    array(
    ‘fields’ => array( ‘ID’, ‘user_login’ )
    )
    );

    With large data of wordpress, this code creates a large load on the database.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author dFactory

    (@dfactory)

    Hi,
    Thanks for your feedback – we’ll definitelly have a look at it and try to provide a fix in a next release of the plugin.

    I can confirm this behaviour.

    On a site with more than 200k users, a post update takes around 20 seconds to complete with the plugin activated. When I deactivate the plugin, the same post takes no more than 10 seconds. I do see the slow get_users query too.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Slow sql query in function’ is closed to new replies.

Tags