Data storage – core tables or custom table

  • Resolved dmac

    (@darrenmcentee)


    1 year 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 3 replies - 1 through 3 (of 3 total)
  • Plugin Support robertabela

    (@robert681)

    1 year ago

    Thank you for showing interest in our plugin @darrenmcentee

    The activity log is stored in two different custom tables. It is not stored in an of the WordPress core tables. You can refer to the WP Activity Log database documention for all the technical details.

    Once you install the plugin you can also configure the activity log retention policy, so you can manage the space they use. The plugin also has a feature to store the logs in an external database, however, that is a premium feature.

    I hope the above helps. Should you have any further questions, please do not hesitate to ask.

    Thread Starter dmac

    (@darrenmcentee)

    1 year ago

    Thank you Robert, cheers for the clarification on that.

    Plugin Support robertabela

    (@robert681)

    1 year ago

    You’re welcome. Should you have any other questions, please do not hesitate to ask.

    Have a great day.

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

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