MSLS plugin executing 4800+ queries on some pages

  • Resolved MJ

    (@maxwelljacobs)


    5 years, 6 months ago

    Hello,

    The multisite language switcher plugin is executing 4800+ queries (according to query monitor) on some of our back-end pages. In particular the settings page for MSLS. We believe this to be a significant factor for a slow loading back-end.

    We’ve had a few problems over the last month regarding this plugin including multisite configuration issues and slow loading back-end.

    Hoping you can help resolve our issue.

    Thanks in advance!

    Max

    • This topic was modified 5 years, 6 months ago by MJ.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Dennis Ploetner

    (@realloc)

    5 years, 6 months ago

    Hello,

    this is quite strange because the options of MSLS are loaded when WordPress requests all of those that are set to autoload (this is also true for the dashboard). Please, elaborate a bit and share some more info!

    Cheers

    Thread Starter MJ

    (@maxwelljacobs)

    5 years, 6 months ago

    Hi Dennis,

    Thanks for the response!

    Yes strange indeed.

    Please see screenshot link below showing a total of 4813 queries from ‘WP_User_Query->query()’.

    https://prnt.sc/pxame5

    Let me know if you need any more information.

    Talk soon,

    Max

    Plugin Author Dennis Ploetner

    (@realloc)

    5 years, 6 months ago

    These are not queries but users … do you have 4813 users in your table?

    Thread Starter MJ

    (@maxwelljacobs)

    5 years, 6 months ago

    Thanks for clarifying Dennis.

    Yes you are correct, there are that many users.

    I think I mentioned the wrong query. Apologies. It’s shown as ‘Update Meta Cache’ and is being queried 1000’s of times by MSLS. It appears to be updating the meta cache for each user.

    Is this meant to happen? It appears to be making the back-end extremely slow…

    Here’s another screenshot showing the query for each user.

    https://prnt.sc/pxame5

    It’s showing 5000+ queries on the page, of which ~4800 are coming from MSLS.

    Thanks for your help so far.

    • This reply was modified 5 years, 6 months ago by MJ.
    • This reply was modified 5 years, 6 months ago by MJ.
    Plugin Author Dennis Ploetner

    (@realloc)

    5 years, 6 months ago

    The links seem the same 😉

    No this is probably because of the plugin queries the users. I added a filter to the plugin so you can customize the user query. The version is on GitHub:

    https://github.com/lloc/Multisite-Language-Switcher

    Read on here: http://msls.co/developer-docs/hook-reference.html#msls-get-users

    Thread Starter MJ

    (@maxwelljacobs)

    5 years, 6 months ago

    Hi Dennis,

    Lol sorry! It’s been a long day!

    Thanks for the github link and your help.

    Keep up the great work!

    All the best,
    Max

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘MSLS plugin executing 4800+ queries on some pages’ is closed to new replies.