Understanding ACF data storage

• iamrobertandrews

• December 9, 2022 at 7:07 am

I know you have dealt with a lot of “How does ACF store data?” questions over the years.

I have been noting-down what I think I have learned, and I want to post it for sense-checking…

### Field Group – wp_posts (acf-field-group)

Field Groups (for posts) are stored in the wp_posts as post_type acf-field-group.

Eg.
– post_title – Post – Article, Viewpoint & Report fields
– post_name – post-article-viewpoint-report-fields
– post_excerpt – source_url
– post_content –
`json
a:13:{s:8:”location”;a:3:{i:0;a:1:{i:0;a:3:{s:5:”param”;s:9:”post_type”;s:8:”operator”;s:2:”==”;s:5:”value”;s:7:”article”;}}i:1;a:1:{i:0;a:3:{s:5:”param”;s:9:”post_type”;s:8:”operator”;s:2:”==”;s:5:”value”;s:9:”viewpoint”;}}i:2;a:1:{i:0;a:3:{s:5:”param”;s:9:”post_type”;s:8:”operator”;s:2:”==”;s:5:”value”;s:6:”report”;}}}s:8:”position”;s:15:”acf_after_title”;s:5:”style”;s:7:”default”;s:15:”label_placement”;s:3:”top”;s:21:”instruction_placement”;s:5:”label”;s:14:”hide_on_screen”;s:0:””;s:11:”description”;s:0:””;s:12:”show_in_rest”;i:0;s:18:”acfe_display_title”;s:0:””;s:13:”acfe_autosync”;s:0:””;s:9:”acfe_form”;i:0;s:9:”acfe_meta”;s:0:””;s:9:”acfe_note”;s:0:””;}
`

### Post Field – wp_posts (acf-field)

Individual fields (items of a Field Group) (for posts) are stored in the wp_posts as post_type acf-field.

Eg.
– post_title – Source URL
– post_name – field_5b39e6dc170b7
– post_excerpt – source_url
– post_content –
`json
a:7:{s:4:”type”;s:3:”url”;s:12:”instructions”;s:0:””;s:8:”required”;i:0;s:17:”conditional_logic”;i:0;s:7:”wrapper”;a:3:{s:5:”width”;s:0:””;s:5:”class”;s:0:””;s:2:”id”;s:0:””;}s:13:”default_value”;s:0:””;s:11:”placeholder”;s:0:””;}
`

—

## Post meta data

### wp_postmeta

The wp_postmeta table stores meta fields for WordPress posts.
Each meta item has an entry, linked to the post ID.
– meta_id
– post_id
– meta_key
– meta_value

#### 1. Actual data

ACF stores the **data** as WordPress expects, eg:
– meta_key: source_url
– meta_value: [https://www.example.com/my/added/page.html](https://www.example.com/my/added/page.html)

#### 2. ACF meta

However, it also keeps a second meta item to link it to the ACF Field Group information.
– meta_key: _source_url
– meta_value: field_5b39e6dc170b7

This is a signpost that allows ACF to link this field back to the Field data.
– “field_5b39e6dc170b7” is the ACF name of the native field “source_url”
– “field_5b39e6dc170b7” the post_name of the field stored in wp_posts, with post_title “Source URL”.

#### ACF saves postmeta with null values

Even for actual WordPress postmeta data, ACF appears to create wp_postmeta records for ACF fields with no meta_value. (2022-12-09: there were 24,013 such records with zero meta_value).

## Summary

– Field Group information is stored as posts.
– Field information is stored as posts.
– ACF keeps 2x as much postmeta as necessary (2022-12-09: 237,853 entries in wp_postmeta)
– It also keeps blank meta records.

—

## Questions

– Will deleting a field delete the corresponding wp_post item of type acf-field?
– Will deleting a field group delete the corresponding wp_post item of type acf-field-group?

– In a scenario in which ACF is no longer used, deleting all wp_postmeta with values field_* should help tidy things up, right?
– If I want to delete all the blank postmeta records that have been saved, I should select them with SELECT * FROMwpcxt_postmetaWHEREmeta_keyIS NOT NULL ANDmeta_value= '' and delete, right?

• John Huebner

• December 18, 2022 at 11:28 am

– Will deleting a field delete the corresponding wp_post item of type acf-field?

Yes

– Will deleting a field group delete the corresponding wp_post item of type acf-field-group?

Yes, an it will also delete all of the fields in that field group

– In a scenario in which ACF is no longer used, deleting all wp_postmeta with values field_* should help tidy things up, right?

This will only delete the field key references and not the field data

– If I want to delete all the blank postmeta records that have been saved, I should select them with SELECT * FROMwpcxt_postmetaWHEREmeta_keyIS NOT NULL ANDmeta_value= ” and delete, right?

Yes, this would delete all of the entries with empty values.