Segment (device type) not loading


I recently set up a segment for devicetype=smartphone and set it to pre-processed. I made sure that the crontab does it’s job. The graphs still don’t load thought. The graphs time out at some point.

The segment (devicetype=smartphone) should be recording about 1.4 million actions per day.

Any suggestions or ideas to make this work?


After adding a mysql index to piwik_log_visit.config_device_type things work as expected.