Zapier addon issue

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!

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 2 years, 1 month ago by 1earthsangha.
• This reply was modified 2 years, 1 month ago by 1earthsangha.
• This reply was modified 2 years, 1 month ago by 1earthsangha.

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 2 years, 1 month ago by 1earthsangha.

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