StatComm (StatPress Community) Multisite Edition
reducing database size (3 posts)

  1. fergus440
    Posted 2 years ago #

    My site has become extremely slow. The reason seems to be that the database has grown to a few hundred thousand lines. I display 10 days and have no need for retaining more than that. How can I reduce the size of the database?


  2. WPReady
    Plugin Author

    Posted 2 years ago #

    Hi fergus440,
    thanks for your comments.

    You can restrict datatable size settings this values on Statcomm->options

    Also collect data about logged users
    Do not collect spiders visits
    Automatically delete visits older than... (by default is no limit, set 1 month or 1 week)
    Automatically delete spiders older than...(by default is no limit, set 1 month or 1 week)

    Also there is an issue preventing to delete some data, this will be fixed on next version, see http://wordpress.org/support/topic/auto-delete-logs-settings-is-not-working-fixed-inside?replies=2

    Best regards

  3. fergus440
    Posted 2 years ago #

    Thanks for the timely response. I had already set the values you suggest except the logged users and spiders but the lines have not been removed (over 800k). I also installed the WP-Optimize plug-in but that didn't do what I expected. My site is somewhat faster but still the slowest site I frequent. Would uninstalling and reinstalling with your suggested options work? Again, thans.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic