Have you enabled auto-archieving? Have a look here: http://piwik.org/docs/setup-auto-archiving/ http://piwik.org/docs/setup-auto-archiving/ If that isn't enoug

Have you enabled auto-archieving? Have a look here: http://piwik.org/docs/setup-auto-archiving/ http://piwik.org/docs/setup-auto-archiving/ If that isn't enough http://piwik.org/docs/optimize-how-to/ http://piwik.org/docs/optimize-how-to/ shows you how to configure php and mysql for more performance. Actual hardware requirements are quite small for small sites (say < 10k visitors/day). Any 10-15$ VPS should be fine.