Zapier addon issue

  • Resolved snbhavik

    (@snbhavik)


    3 years, 9 months ago

    Zapier addon creating too many records in options table for wp_give_zapier_trigger with autooad yes. It impacts on the SB and site performance. May I know if those options really need autoload yes or not.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Rick Alday

    (@mrdaro)

    3 years, 8 months ago

    Hi @snbhavik,

    The short answer is no, the records don’t need to autoload and you can delete them from the DB after a backup.

    That said, per WordPress forum rules we cannot offer support for our paid add-ons here. If you want, we can continue the conversation through our Priority Support email available through your givewp.com account.

    Thanks!

    1earthsangha

    (@1earthsangha)

    3 years, 8 months ago

    Ditto! Running this query on our database,

    SELECT * FROM wp_options WHERE option_name LIKE '%wp_give_zapier_trigger%' AND autoload='yes'

    returned over 1700 entries. Yikes. This was cited by our performance analyst as a principal contributor to our page load time. And it gets worse.

    Deactivating the GiveWP Zapier Add-on didn’t remove the rows nor did deleting it. What is the recourse for site owners when they delete a plug-in and it leaves this horror behind? (That’s not a real question.)

    For those facing this problem, here’s what we did

    DELETE FROM wp_options WHERE option_name LIKE '%wp_give_zapier_trigger%'

    Entire site: faster.

    • This reply was modified 3 years, 8 months ago by 1earthsangha.
    • This reply was modified 3 years, 8 months ago by 1earthsangha.
    • This reply was modified 3 years, 8 months ago by 1earthsangha.
    1earthsangha

    (@1earthsangha)

    3 years, 8 months ago

    Amendment. The recommended threshold of autoloaded data is 800 to 900kb.

    In deleting these wp_give_zapier_trigger rows from wp_options, the size of our autoloaded data went from 36Mb to 516kb.

    SELECT SUM(LENGTH(option_value)) as autoload_size FROM wp_options WHERE autoload='yes'

    • This reply was modified 3 years, 8 months ago by 1earthsangha.
    Thread Starter snbhavik

    (@snbhavik)

    3 years, 8 months ago

    Hello @mrdaro,

    Thank you for the answer. I’ll reach out to you by email.

    @1earthsangha

    Thank you for the query, I already deleted that records and the website is working fine now.

    Thanks all

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

The topic ‘Zapier addon issue’ is closed to new replies.