Data storage – core tables or custom table

  • dmac

    (@darrenmcentee)


    1 year, 2 months ago

    Hi,
    I’m scoping out this plugin for a potential client project and have questions about your data storage approach.

    Specifically, I need to know:
    Where do you store user settings and event log entries – in WordPress core tables or in custom tables?
    How do you handle data growth, particularly for event logs which may accumulate significantly?

    Our client’s project will likely generate substantial data, and we’re concerned about efficiency if data is stored in wp_posts and wp_postmeta tables, which can grow quickly with regular posts or CPTs.

    I’m looking for the most efficient solution for this implementation.
    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Yakir Sitbon

    (@kingyes)

    1 year, 2 months ago

    Hi,
    We use two types of data:

    1. User settings stored in the wp_options table.
    2. Event log entries stored in a custom table.

    In the settings, you can configure when to clean up old entries.

    Additionally, if your installation is multisite, each site has its own separate table.

    Thread Starter dmac

    (@darrenmcentee)

    1 year, 2 months ago

    Thank you Yakir, cheers for the clarification on that.

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

The topic ‘Data storage – core tables or custom table’ is closed to new replies.