Slow Query

  • eltoine

    (@eltoine)


    4 years ago

    Hi, our plugin query monitor shows us always a slow query from your plugin:

    UPDATE hadsp_options
    SET option_value = ”
    WHERE option_name = ‘berocket_current_displayed_notice’ +
    update_option()
    Plugin: load-more-products-for-woocommerce

    Can you please help us fixing that or update your plugin so it doesnt show a slow query from your plugin?

    Thanks a lot.

    Elton Ferati

    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)

    4 years ago

    Hi Elton,

    Looks weird. This is simple query that is updating 1 row only.

    We will check the query but I’d recommend you to check your sql server configuration/speed too.

    Regards,
    Dima

    Thread Starter eltoine

    (@eltoine)

    4 years ago

    Hi Dima

    Thanks for answer. I wait for your help.

    what should I ask the hosting company exactly for the sql server configuation/speed?

    thanks

    elton

    Thread Starter eltoine

    (@eltoine)

    4 years ago

    I asked hosting company and they say the SQL Server configuarion is fine. So I wait for your answer.

    Thanks.

    Plugin Author Dmytro Holovnia

    (@dholovnia)

    4 years ago

    Hi Elton,

    UPDATE hadsp_options SET option_value = '' WHERE option_name = 'berocket_current_displayed_notice' is a simple single value update. You need to index the option_name column to make it work faster.

    We cannot remove this query.

    Regards,
    Dima

    Thread Starter eltoine

    (@eltoine)

    4 years ago

    Hi. ok thanks, but how can I index the column and with what plugin? We use WPRocket?

    Plugin Author Dmytro Holovnia

    (@dholovnia)

    4 years ago

    Hi, you need to open database with phpmyadmin and for the option_name in table hadsp_options add an index.

    Regards,
    Dima

    Thread Starter eltoine

    (@eltoine)

    4 years ago

    Can you please explain exactly how it must look like? I think you mean i need to insert by clicking insert and then I need to fill in what axactly and where?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Slow Query’ is closed to new replies.