Custom database tables

Hello,

Thanks for the feedback!

Some people requested this a while back, but to be honest it is a big feature that is out of the scope of the plugin right now. I need to stay focused on other upcoming features first, but maybe in the future, I can’t guarantee it.

In the meantime, if you’re looking for performance DB optimization with ACF, you may want to take a look at the Single Meta Save module, which is even faster since all post ACF values are compressed into one single DB meta row. Kinda similar to Gutenberg which save everything as json in the post_content field.

Have a nice day!

Regards.

Thank you very much for your prompt answer. I had not even looked at that before.
However I do not understand what does “Save as Individual Meta” setting do at the database level? Is it going to affect performance if enabled? WP Queries and Meta Queries options are needed by most users I guess!

Hello,

The “Save as individual meta” is a new setting that will be available for any fields in any field groups, when the Single Meta Save is activated.

This setting is here because when using Single Meta Save, all meta are compressed into one single array. On the front-end, when you will use a WP_Query with a meta_query, WordPress will not be aware of that custom ACF logic, so you won’t be able to perform a normal meta_query since all the values are inside one unique acf meta.

For the specific fields which have “Save as individual meta” enabled, ACF will keep saving a normal DB row my_field & _my_field in addition of being inside the acf meta. This way you’ll be able to keep using WP_Query on the front-end, just like before.

So before activating it, you’ll have to check all your front-end meta_query to know which fields have to be still “Saved as individual meta”. Generally you only have few fields that are actually used for this purpose, so it shouldn’t be too hard to find them.

Hope it helps!

Regards.

OK now it is clear! Thank you again for your support! I would have given 6 stars if I could!

Thank you @smatzis ??