Database gets very slow when Plugin is active

  • Hello, actually I liked you plugin very much but recognized now, that product create and edit and also order status change takes like 45 seconds when the plugin is active. When I deactivate its the usual 2-3 seconds.

    I checked the processes that are running and found following when plugin is active

    UPDATE gxRTKcRxoptions SET option_value = ‘a:193976:{i:0;s:32:\”berocket_alphabet_brand_widget-2\”;i:1;s:32:\”berock…

    SELECT autoload FROM gxRTKcRxoptions WHERE option_name = ‘_transient_br_brands_cache__5_2’

    Any idea what data is updated in the database here?

    Would be great if we could get this to work – Thanks

    Dominique

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Dmytro Holovnia

    (@dholovnia)

    Hello,

    On the product update we are updating about 1 row in our table. As you can guess updating 1 row should not add extra 42+ seconds.

    Lets try to find out what could be the issue.

    1. Please provide full query. Are you using WP Query plugin to check the queries? Could you please check with it what queries are running on the products update, which are slow and copy those queries here?

    2. I’m pretty sure that the issue is in conflict with some other plugin. In most cases some other plugin is adding own query part to ours and this slows everything down. If you have dev/test site please try to turn off other plugins(except WooCommerce and our plugin) one-by-one and check when speed will recover. Would be nice to know what plugin is causing a conflict.

    Regards,
    Dmytro

    Thread Starter domdeutz

    (@domdeutz)

    Hi, sorry for late reply. I was working to get staging updated for testing purposes. In staging I can′t replicate the issue.

    Could you let me know what info you need from WP Query Plugin? I am not a developer and struggeling to use the plugin.

    I would love to use your plugin so would be great if we can figure our which process takes up the time.

    BR Dominique

    Thread Starter domdeutz

    (@domdeutz)

    Hi, I now tested to run the product saving procedure with brands and query monitor plugin active. But in this case I am getting a critical error and therefore I have no data in query monitor.

    This critical error is not logged in the woocommerce status error log.

    Any idea how to address this?

    Thanks

    Dominique

    Plugin Author RazyRx

    (@razyrx)

    Hello,

    From first message it seems plugin trying to update widget data in database.

    Do you use any brand widget on your site and what exactly widgets is it?

    Regards,
    Oleg

    Thread Starter domdeutz

    (@domdeutz)

    Hi, sorry I missed the message. I added a widget to test possibilities but deactivated the widget afterwards. I only had shortcode on a category page.

    At the moment I am using another brand plugin as your plugin is causing the described issue. But as I would like to also purchase your filter plugin it would be great if we could find some way to fix this error.

    Thanks

    Dominique

    Plugin Author Dmytro Holovnia

    (@dholovnia)

    Dominique,

    To fix the issue you need some test/dev site where you can check if this is conflict with some other plugin. Most likely it is a conflict and to fix it we need to find wich plugin is causing this.

    Regards,
    Dmytro

    Thread Starter domdeutz

    (@domdeutz)

    I will see what I can find out. Thank you

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database gets very slow when Plugin is active’ is closed to new replies.