wp_option fields with autoload set to yes

• bhtech

• February 12, 2015 at 11:12 am

Hi Elliot,

I noticed in the readme.txt file that in version 4.3.3 there was a core update that added new logic to set ‘autoload’ to ‘off’ on all values saved in wp_options table.

I noticed in our wp_options table that we have over 4,000 rows from ACF that still have ‘autoload’ set to ‘yes’.

Can I manually update these to ‘no’?

The extra ‘yes’ rows make up more then 3/4 of our wp_options table – obviously effecting load speed.

Would really like some guidance on this as soon as possible.

Thanks,
bhtech

• akmur

• April 23, 2015 at 9:52 pm

Hello, did you ever try this solution? My database is about 70% made of wp_options generated by ACF

• bhtech

• April 24, 2015 at 11:27 am

Hi akmur,

I did manually update the entries to ‘no’.

I also removed a lot of the ACF fields that were no longer needed in the wp_options table – but I can’t remember exactly the details of that.

Cheers

• James

• June 20, 2016 at 8:24 pm

Hi @akmur

I believe you can make use of the update_options() wp function to do this: https://codex.wordpress.org/Function_Reference/update_option