Extremely Slow Dashboard

Hi All,

I am running Piwik 1.4 on a VPS server and tracking 5 websites that have relatively low traffic (100/day each max). However, when I login to my Piwik dashboard, it takes minutes for the data to load up.

Is there anything I should check to see why this is happening? I checked my Error Log and found the following:


[Thu May 12 06:43:14 2011] [error] [client 111.111.114.11] File does not exist: /home/mysite/public_html/robots.txt
[Wed May 11 21:42:24 2011] [error] [client 111.111.5.11] File does not exist: /home/mysite/public_html/404.shtml
[Wed May 11 21:42:24 2011] [error] [client 111.111.5.11] File does not exist: /home/mysite/public_html/robots.txt

and a bunch of errors that look like this:


[Wed May 11 18:48:53 2011] [error] [client 111.251.18.111] <br /><br />Backtrace --><div style="font-family:Courier;font-size:10pt">#0  Piwik_ErrorHandler(2, Division by zero, /home/mysite/public_html/analytics/core/Visualization/Chart/VerticalBar.php, 65, Array ([dataSetsToDisplay] => Array ([0] => nb_visits),[dataSetToDisplay] => nb_visits,[bar] => bar_filled Object ([type] => bar_filled,[colour] => #3B5AA9,[outline-colour] => #063E7E,[alpha] => 0.5,[text] => Visits,[font-size] => 12,[tip] => #val# #key#),[yValues] => Array ([0] => 0,[1] => 0,[2] => 0,[3] => 0,[4] => 0,[5] => 0,[6] => 0,[7] => 0,[8] => 0,[9] => 0,[10] => 0,[11] => 0,[12] => 0,[13] => 0,[14] => 0,[15] => 0,[16] => 0,[17] => 0,[18] => 0),[labelName] => Visits,[unit] => ,[barValues] => Array ([0] => bar_value Object ([top] => 0,[tip] => 0h<br><b>0</b> Visits (0%)),[1] => bar_value Object ([top] => 0,[tip] => 1h<br><b>0</b> Visits (0%)),[2] => bar_value Object ([top] => 0,[tip] => 2h<br><b>0</b> Visits (0%)),[3] => bar_value Object ([top] => 0,[tip] => 3h<br><b>0</b> Visits (0%)),[4] => bar_value Object ([top] => 0,[tip] => 4h<br><b>0</b> Visits (0%...#1  Piwik_Visualization_Chart_VerticalBar->customizeChartProperties() called at [/home/mysite/public_html/analytics/core/ViewDataTable/GenerateGraphData.php:127]#2

You should setup: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo