[quote=dali]I presume you already have a PHP accelerator (I use Xcache), that makes a huge difference.
I use APC but yes PHP Accelerators make a huge amount of difference. We recently load tested our infrastructure and part of that included Piwik. I hadn’t set up the infrastructure so when the guy who was working on it was reporting poor Piwik performance, I asked if he’d set up PHP caching which he hadn’t. After getting that up and running everything was much better and we didn’t have to throw endless hardware at the servers.
Go to Settings > System check. If the line LOAD DATA INFILE is green then Piwik uses LOAD DATA INFILE.[/quote]
Yup it’s showing up as green on the Piwik server I’m working on
We have another Piwik infrastructure set up for a different product which we can’t get to show this. I’m not sure if this is because the DB and APP are on separate servers, or if it’s an issue with the particular version of PHP on that server, Ubuntu 12.04 LTS, because INFILE has been manually tested as working in the folder on the DB server.