Is postmeta table used even after making table-based pods

  • Resolved noellarkin

    (@noellarkin)


    2 months, 1 week ago

    The pods I’ve made are all table-based. But I’m still getting entries in the postmeta table even though the wp_podsrel table is storing the relationships. Is this normal?

    Eg, in the wp_postmeta table I’m seeing these entries (portfolio and style are pods custom post types with table storage):


    | Edit  | Copy  | Delete | 58681 | 170 | _pods_portfolio  | a:1:{i:0;i:64;} |
    | Edit  | Copy  | Delete | 58682 | 170 | _portfolio       | 64     |
    | Edit  | Copy  | Delete | 58683 | 64  | _style           | 162    |
    | Edit  | Copy  | Delete | 58684 | 64  | _style           | 243    |
    | Edit  | Copy  | Delete | 58685 | 64  | _style           | 251    |
    | Edit  | Copy  | Delete | 58686 | 64  | _style           | 252    |
    | Edit  | Copy  | Delete | 58687 | 64  | _style           | 170    |

    And the podsrel table:


    | Edit | Copy | Delete | 89  | 43 | 144 | 64 | 135 | 138 | 162 | 0 |
    | Edit | Copy | Delete | 249 | 43 | 144 | 64 | 135 | 138 | 251 | 2 |
    | Edit | Copy | Delete | 95  | 43 | 129 | 64 | 47  | 130 | 164 | 1 |
    | Edit | Copy | Delete | 248 | 43 | 144 | 64 | 135 | 138 | 243 | 1 |
    | Edit | Copy | Delete | 94  | 43 | 129 | 64 | 47  | 130 | 165 | 0 |
    | Edit | Copy | Delete | 250 | 43 | 144 | 64 | 135 | 138 | 252 | 3 |
    | Edit | Copy | Delete | 76  | 43 | 129 | 64 | 47  | 130 | 157 | 2 |

    I thought table storage meant these relationships would be stored in wp_podsrel? Would love some clarity on this.

    • This topic was modified 2 months, 1 week ago by noellarkin.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    We keep a copy of data in postmeta even for table based post types for maximum compatibility with other plugins and WP_Query usage.

    There’s an add-on available which I built that can disable that and it deals with the complexities of the queries within Pods to ensure it’s always querying just the correct place it needs to for table based versus meta based Pods.

    https://pods-pro.skc.dev/downloads/advanced-relationship-storage/

    Thread Starter noellarkin

    (@noellarkin)

    Hi, thanks for clearing that up!
    So I’ll need to use the paid plugin?
    I just noticed that the plugin is only available as part of a bundle…is there any option for buying just the one plugin? tbh the only feature I need is for it to not store anything in postmeta.
    Appreciate the help!

    Thread Starter noellarkin

    (@noellarkin)

    PS: never mind, did the math, I doubt with the amount of data I have I’ll need to use the table-based thing, I think I’ll just stick to postmeta for now.

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    It’s a highly specialized solution so it takes more effort to support and maintain. Table based storage isn’t for all use-cases and you are probably right that you’re safe with meta for yours.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.