performance issue : wp_slicewp_commissions queries

  • Resolved tonuz

    (@tonuz)


    2 months ago

    Hello Team,

    We have identified a performance issue where the SliceWP plugin is generating over 400 queries related to the wp_slicewp_commissions table in a short period. This high query volume is causing significant load on our MySQL database and impacting the overall server performance. Here are a few examples of the queries:

    | 11619104 | wqv4vko_untz | localhost | wqv4vko_untz | Query | 0 | Sending data | SELECT * FROM wp_slicewp_commissions WHERE 1=1 AND status = 'unpaid' AND affiliate_id = '314' AND | 0.000 || 11619105 | wqv4vko_untz | localhost | wqv4vko_untz | Query | 1 | Sending data | SELECT affiliate_id FROM wp_slicewp_commissions WHERE 1=1 AND status = 'unpaid' AND payment_id = ' | 0.000 || 11619110 | wqv4vko_untz | localhost | wqv4vko_untz | Query | 0 | Sending data | SELECT * FROM wp_slicewp_commissions WHERE 1=1 AND status = 'unpaid' AND affiliate_id = '471' AND | 0.000 || 11619111 | wqv4vko_untz | localhost | wqv4vko_untz | Query | 0 | Sending data | SELECT * FROM wp_slicewp_commissions WHERE 1=1 AND status = 'unpaid' AND affiliate_id = '314' AND | 0.000 |

    Is there anyway to optimize this ?

    Regards,

    Antoine

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author iova.mihai

    (@iovamihai)

    2 months ago

    Hey @tonuz,

    Thank you for reaching out! Please open a technical issue support ticket about this on our website: https://slicewp.com/contact/

    Please also specify where you’re seeing these queries. Are they being run only within SliceWP’s admin pages or anywhere else?

    Once we know more details, we hope to be able to let you know more and help improve the situation.

    Thank you and best wishes,

    Mihai

    Plugin Author iova.mihai

    (@iovamihai)

    1 month, 3 weeks ago

    Hey @tonuz,

    We have been inspecting the situation you’ve reported and I believe I have found the system that’s resulting in all of the queries you’ve mentioned.

    I have not found any support tickets opened by you on our website, so I will provide some details here.

    From what I see, the issue could be with the system that’s checking if you have payments ready to be paid to your affiliates. This system will check against any unpaid commissions that you may have.

    Can you please let me know if you have a large number of commissions that have the status “unpaid”?

    Thank you and best wishes,

    Mihai

    Plugin Author iova.mihai

    (@iovamihai)

    1 month, 1 week ago

    Hey @tonuz,

    In the meantime, we’ve looked over the system I’ve mentioned in my previous reply and we’ve refactored it to be way more efficient. With the new system in place you should no longer see all of the queries mentioned.

    We’re in the testing phases of this new system and we’re looking to release it in the following days.

    Thank you and best wishes,

    Mihai

    Thread Starter tonuz

    (@tonuz)

    1 month, 1 week ago

    Hi team,

    Thanks for this, waiting for the release to test it.

    Regards,

    Antoine

    Plugin Author iova.mihai

    (@iovamihai)

    1 month, 1 week ago

    Hey @tonuz,

    If you’re open to testing this new plugin update right away, I’m happy to share it with you. Just open a support ticket on our website (here: https://slicewp.com/contact/) and I’ll get back to you as quickly as possible.

    Thank you and best wishes,

    Mihai

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

You must be logged in to reply to this topic.