High CPU usage due to WP Statistics

Hi,

Thank you. I downloaded the file again, and tested again. Same results:
– extremely slow loading of statistics in the dashboard (only part of the graphs loading the others forever loading which leads to jump in CPU usage)
– widget on the webpage still not visible as before to include the visitor/visits details

Here is an example of some slow queries prior to the point I tried to actually load the dashboard:

Slow Database Queries (above 0.05s)
Query Caller Component Rows Time
SELECT COUNT(ID)
FROM wp_ufsg_statistics_visitor
+
WP_Statistics_Admin_Pages::optimization()
wp-content/plugins/wp-statistics/includes/classes/class-wp-statistics-admin-pages.php:236
Plugin: wp-statistics 1 0.1248
SELECT COUNT(uri)
FROM wp_ufsg_statistics_pages
+
WP_Statistics_Admin_Pages::optimization()
wp-content/plugins/wp-statistics/includes/classes/class-wp-statistics-admin-pages.php:238
Plugin: wp-statistics 1 0.1122
SELECT COUNT(ID)
FROM wp_ufsg_statistics_search
+
WP_Statistics_Admin_Pages::optimization()
wp-content/plugins/wp-statistics/includes/classes/class-wp-statistics-admin-pages.php:240
Plugin: wp-statistics 1 0.1023
SELECT DISTINCT agent
FROM wp_ufsg_statistics_visitor
+
wp_statistics_ua_list()
wp-content/plugins/wp-statistics/includes/functions/functions.php:412
Plugin: wp-statistics 298 0.0753

Kind regards,
Daniel

Hi,

Actually we did many changes to optimize PHP codes for now,
But Yes, We will optimize SQL queries in next week
So be patient
We will have great news
You can get latest changes here at any time
https://github.com/wp-statistics/wp-statistics/archive/master.zip
You can see we had many changes in code:
Here is code frequency:
https://github.com/wp-statistics/wp-statistics/graphs/code-frequency

Hi,

Now I went through various support subjects and found out that I am not the only one having this issue, i.e. more people reporting similar issues as WP Stats is trying to retrieve info in admin panel but would never stop and cause high CPU usage. So it is clear to me the plugin doesn’t work anymore in its current form and combo with current Worldpress version.

While you are trying to make it work, can you please let me know where I ca access an older versions of WP Statistics and so I can check which one was the right one?

I must say that the things got worse recently, but I think I have seen it becoming worse and worse in terms of retrieving the data in admin panel, during the past months. Maybe this piece of info fits in to the puzzle you are trying to solve.

Thanks again for all your efforts,
Daniel

Could you please check new version and let us know about the changes?

Dear DediData,

I upgraded to the new version, and:
– the stats in the admin page are now finally loading (I did not checked yet if there is still an impact on the CPU usage but I expect to be not much anyway since it is successfully loading)
– the widget with stats is now working again

Thank you. Keep up the good work.
(I also made a donation.)

Kind regards,
Daniel