Database Size

  • Resolved phillipsburgh

    (@phillipsburgh)


    6 years, 1 month ago

    Hi,

    is it normal that Statify needs 90 MB of database-space? Just checked my database and found an entry wp_statify with a size of nearly 90 MB….

    Could need some advice

    Thank you

    Stephan

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Patrick Robrecht

    (@patrickrobrecht)

    Hi,

    Statify stores one entry per page view. A cron job regularly deletes all entries older than the data saving period (default: 14 days, can be changed to any number of days in the configuration).

    So the size of the database table wp_statify depends upon the number of page views and the period of data saving. However, 90 MB sounds quite much. You may check whether the cron job is running correctly:

    a) Compare the oldest entry (found via a query on the database) with the period of data saving.

    b) WP Crontrol helps to check registered cron jobs. There should be an cron event statify_cleanup executed once daily.

    Cheers
    Patrick

    The database size could be greatly decreased by saving visit for each target as a daily count and by having a second table that saves the count for each referrer.

    Saving each and every visit as a separate entry is a bit overkill.

    I would also recommend to show the default 14 days setting a bit more prominent on the plugin page. That information is easy to miss.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Size’ is closed to new replies.