Data storage – core tables or custom table

  • Resolved dmac

    (@darrenmcentee)


    1 week, 4 days 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 P?r Thernstr?m

    (@eskapism)

    Hey, that are really good questions.

    I updated this page today to hopefully be able to answer your questions:
    https://simple-history.com/support/gdpr-and-privacy/

    tldr; we use two custom tables and personally I haven’t had any problem with any number of stored logs, but there have been other users who have reported the logs being slow to access or to db being large when they get hundreds of thousands login attempts. There is probably a very big different between users on shared low cost hosting and premium VPS users or similar.

    Hope the above helps!

    Thread Starter dmac

    (@darrenmcentee)

    Thank you P?r, cheers for the clarification on that. It looks like a good solution for us.

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