Support » Plugin: WP Statistics » Get rid of all the database data

  • Resolved justillon



    the visitor an pages tables have some hundred thousand lines after some months now.

    Is there any way to keep the numbers (visitors, visits, per month, per year, etc) and informations (like how many hits per article) but get rid of all the database lines?

    Like “compressing” the database and only keep absolute values.

    Thank you!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Greg Ross


    Yes and no.

    If you use the purge function (Statistics->Optimization->Purging->Purge records older than), it will update the historical values (Statistics->Optimization->Historical) for the pages, visits and visitors stats.

    However these are only applied to the totals, not on a monthly or yearly basis.

    Ok, I guess this only works with the “older than” version. I tried the other version and pruned all tables “right now” and everything was set to zero. At least it was only a dev copy of the blog 😉

    So If use the “older than” funkction, will it keep the wp-admin/admin.php?page=wps_pages_menu data? Will I still see the “all time” ranking of which pages were viewed most? Or only the data since the last prune?


    Plugin Contributor Greg Ross


    Yes, the empty tables code doesn’t keep the historical results, only the “older than” option.

    Yes, pages data is maintained.

    Of course before you do the purge, you should backup your data just in case.

    You should definitely work on the german translation.

    Instead of purge and empty it says “leeren” and “löschen” which means “empty” and “delete”. Very confusing!

    Plugin Contributor Greg Ross


    We can use any help you can offer on it. The translations are a combination of automated and volunteer work.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Get rid of all the database data’ is closed to new replies.