Title: Loading issue Dashboard Last modified: August 30, 2016 --- # Loading issue Dashboard * Resolved [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 8 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/) * Hi Greg, * On one of my installation, with lots of traffic, i have an issue with the loading times on my Dashboard. * Loading Dashboard takes about 1min. – When turning off Top 10pages, and Top 10 Referral sites, the speed is back ok. * – Top 10pages, for examples / remark got 50.000hits. – Top 10 Referral sites for example, google.com 40.000+ facebook 30k+ etc. This is only after 3month of installation time. * I think there is an loop or something in the loading scripts. Could you test this on a big database? * If you need more information let me know. * [https://wordpress.org/plugins/wp-statistics/](https://wordpress.org/plugins/wp-statistics/) Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/loading-issue-dashboard/page/2/?output_format=md) [→](https://wordpress.org/support/topic/loading-issue-dashboard/page/2/?output_format=md) * Plugin Contributor [Greg Ross](https://wordpress.org/support/users/gregross/) * (@gregross) * [10 years, 8 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592110) * Have you updated to the new search table code? * Thread Starter [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 8 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592163) * Was that the option under Optimalisation, that you had to convert the datebase? Then i have done that. * Have tested it on a other site, with those 2 off, load speed of admin screen goes from 3 sec to less then 1 sec. That site got less traffic then the other. * Thread Starter [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 8 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592168) * Got more info: * Dashboard open with only “Top 10 Pages” selected as view. It makaes 9500 query’s to load the page. * Queries by Caller Caller SELECT wp_statistics_uri_to_id() 2,625 1.0825 wp_statistics_pages() 2,625 1.0034 WP_Statistics->Get_Historical_Data() 2,625 0.7684 WP_Post::get_instance() 1,590 0.7494 wp_count_posts() 2 0.0404 wp_load_alloptions() 1 0.0180 * Queries by Component Component SELECT Plugin: wp-statistics 9,465 3.6136 Core 17 0.0668 * Plugin Contributor [Greg Ross](https://wordpress.org/support/users/gregross/) * (@gregross) * [10 years, 8 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592174) * How many rows are in your wp_statistics_pages and other databases? (you can see the number of rows in optimization page). * Thread Starter [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 8 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592178) * Number of rows in the prefix_statistics_pages table: 4,187 Row * Plugin Contributor [Greg Ross](https://wordpress.org/support/users/gregross/) * (@gregross) * [10 years, 8 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592336) * And the other tables? * Thread Starter [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592385) * Still slow yes, what do you mean with other tables? Want an other prinscreen? * Did you find the issue? (Because it says resolved) * Plugin Contributor [Greg Ross](https://wordpress.org/support/users/gregross/) * (@gregross) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592400) * Row count for your other wp_statistics tables. * Not resolved, but if I don’t get a response after a week I close a the ticket. * Thread Starter [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592403) * Wow you made me respond fast! 🙂 Here you go! * TABLE ROWS TYPE COLLATION SIZE wp_statistics_exclusions 0 InnoDB utf8_general_ci 48 KiB wp_statistics_historical 0 InnoDB utf8_general_ci 64 KiB wp_statistics_pages 59,303 InnoDB utf8_general_ci 28,3 MiB wp_statistics_search 89,365 MyISAM utf8_general_ci 6,8 MiB wp_statistics_useronline 12 InnoDB utf8_general_ci 16 KiB wp_statistics_visit 174 InnoDB utf8_general_ci 32 KiB wp_statistics_visitor 53,643 InnoDB utf8_general_ci 21,6 MiB * Need more information? Or a mysql dump of the tables? * Thread Starter [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592404) * If you have an website, with an database the size as mine. * You could install the plugin Query Monitor * then you can see the ammount of query’s and the time it takes. * Plugin Contributor [Greg Ross](https://wordpress.org/support/users/gregross/) * (@gregross) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592406) * How many rows are in each table? * Thread Starter [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592408) * wp_statistics_exclusions ROWS 0 wp_statistics_historical ROWS 0 wp_statistics_pages ROWS 59,303 wp_statistics_search ROWS 89,365 wp_statistics_useronline ROWS 12 wp_statistics_visit ROWS 174 wp_statistics_visitor ROWS 53,643 * Plugin Contributor [Greg Ross](https://wordpress.org/support/users/gregross/) * (@gregross) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592409) * Search/Pages seem a little strange to be so high with visitors being lower. Can you check to see what the oldest rows are in each of those three tables? * Thread Starter [rorror](https://wordpress.org/support/users/rdehaar/) * (@rdehaar) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592412) * wp_statistics_pages OLDEST ROW 2015-04-24 wp_statistics_search OLDEST ROW 2015- 04-24 wp_statistics_visitor OLDEST ROW 2015-04-24 * Plugin Contributor [Greg Ross](https://wordpress.org/support/users/gregross/) * (@gregross) * [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/#post-6592414) * Have you purged any data in the past? Viewing 15 replies - 1 through 15 (of 16 total) 1 [2](https://wordpress.org/support/topic/loading-issue-dashboard/page/2/?output_format=md) [→](https://wordpress.org/support/topic/loading-issue-dashboard/page/2/?output_format=md) The topic ‘Loading issue Dashboard’ is closed to new replies. * ![](https://ps.w.org/wp-statistics/assets/icon.svg?rev=3081064) * [WP Statistics – Simple, privacy-friendly Google Analytics alternative](https://wordpress.org/plugins/wp-statistics/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-statistics/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-statistics/) * [Active Topics](https://wordpress.org/support/plugin/wp-statistics/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-statistics/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-statistics/reviews/) * 16 replies * 2 participants * Last reply from: [rorror](https://wordpress.org/support/users/rdehaar/) * Last activity: [10 years, 7 months ago](https://wordpress.org/support/topic/loading-issue-dashboard/page/2/#post-6592423) * Status: resolved