So I have a existing wordpress site and we are building now download section for it. Downloads will be custom post type and files. Now we need to have some stats, like number of downloads per cpt (needed) and who downloaded (logged in users) (nice to have). There would few hundred (2009 users each download few files (3-5) each day.
We have been thinking of just creating new table to database and each time someone download something, we add there new line with ref. to cpt id, user id and date. But then again thinking, this might be too heavy for db? Now how would you do this? What would be more efficient and nicer way of doing it?