Skip to:
Content
Pages
Categories
Search
Top
Bottom

MySQL wp_usermeta select large performance issue


  • n0madpl
    Participant

    @n0madpl

    7 years, 5 months ago

    Hey guys,

    I’m having some performance issues with the following database request:
    MySQL wp_usermeta select

    It takes 30% of total processing time
    Average calls per request 5960 – correspond to the number of users…
    Average time in ms is 3,190

    My WordPress version is 4.7.2
    Buddy Press 2.7.4
    PHP 7.0
    Site: https://polocontacts.com
    WordPress 4.7.2 running Superlist / Poloescapes theme.

    Updating the site takes quite a bit of time as it’s heavily customized.

    Please let me know if you’re having the same issue or if you’ve figured out how to lower the server load and increase the performance of the site in general hindered by this request.

    It just seems to be fetching a large list of users, while loading a lot of different subpages.

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

  • n0madpl
    Participant

    @n0madpl

    7 years, 5 months ago

    I’ve also noticed that switching to HHVM improves the performance of the site a lot… but seems like this single query messes up the performance of my whole site, as it’s included in loading of many pages.

    But before I switch permanently from PHP 7 to HHVM I’d like to solve this issue. Any ideas?


    n0madpl
    Participant

    @n0madpl

    7 years, 5 months ago

    @mercime?

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

Topic Info

Topic Tags

Skip to toolbar