This isnt so much a how do I do it question, but more of a what is the best approach to this problem.
My company is creating a site that requires user registration. They asked me to include a user activity logger. This is because they want to 1, monitor which areas of the site is recieving heaviest traffic (which webstats can do), but more importantly give users traffic reports and let them see a history of what they have done on the site.
So basically, i need to record user movement and feature action on the site.
My worry is, having a single "user activity" table would be a good idea because a single user can rack up 100 hits in a single use, time a few thousand users and I'm looking a table with rows in the high hundred k's if not mulit-million pretty quicky. And since everyone must access this table that would kill my sql time.
I think that even if I break up the tables in specific activities that would (althogh certainly help) would still over a short period of time accumulate dramatically.
What are you thoughs on whether mysql can handle the information, or should I have have txt files with user logs for each individual user, which is the solution i'm leaning towards. that way if one user becomes to large of a file it doesnt effect the others.
