Project

General

Profile

Bug #10722

StatPress performance

Added by Boone Gorges 3 months ago. Updated 3 months ago.

Status:
New
Priority name:
Normal
Assignee:
Category name:
-
Target version:
Start date:
2018-11-17
Due date:
% Done:

0%

Estimated time:

Description

We disabled StatPress for new users some time ago, but for existing users, it's a true beast. The database tables are enormous and poorly designed, and the admin is so slow on large sites to be near unusable.

It will be tough to take away people's stats without having a good replacement. I know that we have given per-site access to Google Analytics in the past. Scott, would you mind providing info on how many people are using this, and how hard it is for you to set up when it's requested?

I'd like to explore the possibility of simply removing StatPress from the system, which would mean removing the corresponding database tables. This likely means preparing some sort of report on where it's activated. Some sites that have it turned on may not be active anymore, or may be using a custom Google Analytics report instead. In those cases, it'll be pretty painless to remove.

We may look into a better system for allowing people to link their sites to their own Analytics accounts. See https://support.google.com/analytics/answer/1032400?hl=en. This could be self-service.

In the meantime, there may be things we can do to mitigate the awful performance. See https://www.saotn.org/optimize-wp-statpress-plugin-database-performance/

History

#1 Updated by scott voth 3 months ago

Hi Boone - We have 49 views right now on Google Analytics. It doesn't take too long to set up the view, create a report, notify the user, and make sure it is working - probably about 30 minutes. I think we are reaching our limit of views (50 per property) but apparently you can add properties to an account and accounts to a login - I am not actually sure how this works - see http://gatipoftheday.com/google-analytics-account-limit-raised-from-25-to-100/#

#2 Updated by Boone Gorges 3 months ago

  • Assignee set to Boone Gorges

Thanks, Scott. I'm going to research this a bit more. I think our best path forward may be to allow users to enter their own Google Analytics account info into their WordPress site, and then to transition existing StatPress users over to that system. I'll take some time in the upcoming month or two to see exactly how this would work.

Also available in: Atom PDF