Slow + High mysql CPU usage?

  • Resolved Chad Reitsma

    (@chadreitsma)


    3 years, 10 months ago

    Hey guys,

    I’m noticing some really high mysql CPU usage and slow loading times when we try to load the “Invoices” page in the admin panel (/wp-admin/edit.php?post_type=sliced_invoice)

    Even without any invoices in the database it takes about 5-7 seconds to load the page.

    I have disabled all other plugins except for this one and it still happens, so I’m not sure what’s up. Has anyone else experienced this?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Chad Reitsma

    (@chadreitsma)

    The issue is with your get_clients() function inside of \admin\class-sliced-admin.php

    On websites with 1000+ users this is causing a massive CPU hit – can you change this to an AJAX box asap???

    • This reply was modified 3 years, 10 months ago by Chad Reitsma.
    Plugin Support MeganSupport

    (@megan891)

    Hi @chadreitsma

    Sorry you’re have trouble. Please note that for queries like this a support ticket needs to be logged via our website here https://slicedinvoices.com/support-ticket/ so that we can assist you further.

    Thanks in advance,

    Sliced Invoices Support

    Plugin Author SlicedInvoices

    (@slicedinvoices)

    @chadreitsma just to add to what Megan said, I’ve personally tested Sliced Invoices with several thousands of users and never encountered any problem like what you’re describing. Most likely there is something amiss in your MySQL configuration, or perhaps your MySQL server is starved for resources. I would recommend talking to your host about that.

    If you need further assistance from us though please feel free to open a support ticket… we don’t monitor the wordpress forums regularly (as noted here).

    Best wishes,
    David Grant
    Developer of Sliced Invoices

    Thread Starter Chad Reitsma

    (@chadreitsma)

    Sorry David, but it’s definitely a problem.

    Your get_clients() function is using the WP_Users_Query and loading all user names into the select box. Test it with 10000+ users and you will run into serious lag / problems as you loop over those 10000 users. It should be an AJAX box.

    Plugin Support MeganSupport

    (@megan891)

    Hi @chadreitsma

    We have received your support tickets and will correspond with you via those tickets.

    Thanks,

    WP Wham Support

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Slow + High mysql CPU usage?’ is closed to new replies.