Slow backend woocommerce

  • Resolved erikhellstroem

    (@erikhellstroem)


    1 month, 2 weeks ago

    Hi!
    I hope this message finds you well. We recently disabled and removed the WPLOYALTY plugin from our WordPress/WooCommerce site due to performance concerns. However, we are still experiencing significant slowdowns in our site’s backend, specifically due to an unusually high number of database queries related to the users (usermeta table), which seems unusual for a site with around 1245 users.

    Given that WPLOYALTY was responsible for managing user points and rewards, I’m wondering if the plugin may have left behind residual data or made modifications to the database that are still affecting performance even after its removal.

    Could you please advise on the following:

    1. Are there any specific database entries or tables created by WPLOYALTY that we should clean up manually?
    2. Could there be any changes to the usermeta table that may be causing excessive queries after the plugin was disabled?
    3. Do you have any recommendations for safely cleaning up or optimizing the database after uninstalling WPLOYALTY?

    We appreciate any insights or guidance you can provide to help resolve this issue.

    Thank you for your support!

    //Erik

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

    (@erikhellstroem)

    ?

    Plugin Support haripradeepa

    (@haripradeepa)

    Hi there,

    Thanks for reaching out.

    Please note that deactivating and deleting the plugin won’t remove customer details from the backend. This allows you to retain the data if you decide to reactivate the plugin later.

    However, if you’re aiming to completely deactivate the plugin and remove all backend data, please be aware that once the database is deleted, customer details cannot be recovered.

    Let say for example, here we have added the table prefix as (wp_), the following tables store the relevant data, and deleting them will remove all information from the WPLoyalty plugin:

    • wp_wlr_users
    • wp_wlr_earn_campaign
    • wp_wlr_earn_campaign_transaction
    • wp_wlr_rewards
    • wp_wlr_reward_transactions
    • wp_wlr_user_rewards
    • wp_wlr_referral
    • wp_wlr_logs
    • wp_wlr_levels
    • wp_wlr_points_ledger

    Once these tables are deleted, the data cannot be restored. I hope this helps clarify things!

    Feel free to reach us out in case of any further queries!

    Thanks

    WPLoyalty Team

    Thread Starter erikhellstroem

    (@erikhellstroem)

    Hi!

    Thanks. Have you heard of our problem before and can it be related to your plugin? The slow backend problem as i described.

    So these are the tables that we should look for and delte in that case?

    • wp_wlr_users
    • wp_wlr_earn_campaign
    • wp_wlr_earn_campaign_transaction
    • wp_wlr_rewards
    • wp_wlr_reward_transactions
    • wp_wlr_user_rewards
    • wp_wlr_referral
    • wp_wlr_logs
    • wp_wlr_levels
    • wp_wlr_points_ledger



    //Erik

    Thread Starter erikhellstroem

    (@erikhellstroem)

    Problme solved. Had nothing to do with WPLOYALTY ??

    Plugin Support haripradeepa

    (@haripradeepa)

    Hi there,

    Happy that the issue have been resolved!

    Thanks

    WPLoyalty Team

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