We are currently configuring piwik and we are facing some issues:
- we use import_logs.py on daily files that count more than 2M lines (2000000)
- we need to do some searchs on html files (pages) or pdf files (downloads) that can be consulted heavily or not
- we need to produce statistics on filename (total sum of a specific downloaded file)
today, we tried to use goals, search (in download page), segments, but no solutions
we have configured piwik to load more than 100000 rows in action table and we now encounter perfomance issues on consulting download tab monthly or yearly.
are we using piwik the right way? are there any solution (plugins?) to do some sharp statistics on a particular file?