Move old posts into separate table

  • shanebp

    (@shanebp)


    6 years, 3 months ago

    Anyone tried moving old posts to a separate table, something like _posts_archive ?
    And associated meta to _postsmeta_archive ?
    And writing some custom queries.

    A client wants to move their legacy data into the database, several million posts.
    I don’t want to slow down the usual daily operations, but need the old data available for reports.

    I can’t be the first to encounter this issue.
    For now, I’d like to avoid multiple databases.
    Suggestions?

    • This topic was modified 6 years, 3 months ago by shanebp.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    6 years, 3 months ago

    You’re free to create your own tables for any purpose in the WP database. There will be little WP can do to support such data. You can still use the global $wpdb object to make custom queries, but that’s the extent of WP assistance. It’ll be as though the posts do not exist at all from the WP standpoint. Any presentation of table data needs to be through custom coding.

    Thread Starter shanebp

    (@shanebp)

    6 years, 3 months ago

    Yes, thanks, I understand those points and the goal is for the posts to not exist from the standard WP viewpoint.

    If anyone has implemented such a solution, any specifics would be appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Move old posts into separate table’ is closed to new replies.