Reply To: Empty fields on wp_postmeta

• James

• November 17, 2016 at 3:09 pm

Hi @susa38

Yes, it’s OK for you to delete it. ACF creates them to prepare the database when you need to update them.

It shouldn’t affect your database performance much. But if you have an issue with your site performance, I suggest you use a caching plugin instead.

Yes, you can manually delete the empty database row every time a post is saved, but it will cost more queries and will affect your site performance.

I believe there won’t be any problem if you want to delete them. You can try the following SQL code, but please backup your site and database first.

DELETE FROM wp_postmeta WHERE wp_postmeta.meta_value = ''

Also, please just leave the database if you don’t really need to delete them.

I hope this makes sense 🙂