[Piwik-hackers] Piwik very slow for whatever reasons

[Pelle Boese]

Cheers,

I'm using piwik for a bit now and for sites with more than like 5.000
unique visitors per day it's almost impossible to get the statistics
as it takes too much time to load them. I'm running the latest beta
(0.1.3) on a quite bored quad xeon with 4gb ram and a scsi raid, so
the hardware is definitely not the bottleneck. As soon as I open the
piwik dashboard for this month (stats for one day work), my 'top'
looks like that:

17713 www-data  25   0  214m  72m 9572 R  100  1.9   1:00.00 apache2
1343 mysql     15   0  128m  52m 5868 S    2  1.4 420:21.34 mysqld

after 30 seconds I get one of the following errors for all widgets
while the flash loads forever:

Fatal error: Maximum execution time of 30 seconds exceeded in
/var/www/stats/piwik/modules/DataTable.php on line 861

Fatal error: Maximum execution time of 30 seconds exceeded in
/var/www/stats/piwik/modules/DataTable/Row.php on line 153

As the apache2 child uses 100% CPU, it's probably not a database
problem, but something else going completely wrong in the code.

Any suggestions on that problem?

I'm btw running the following setup:

Debian Sarge
Apache 2.2.3 with mpm_prefork
PHP 5.2.0 with suhosin
MySQL 5.0.32

Cheers, Pelle.

-- 
Pelle Boese
Online Marketing

Concept08 GmbH
Grüngürtelstrasse 77
50996 Köln

Tel:      0172 373.94.56
E-Mail: pelle at concept08.com
Web:   http://www.concept08.com/