3 ms·
I've often wondered about the efficacy of having a simple catch-all script that just tracks everything a user does on the site. I would think it would pound the
by pc86 14y ago
I've often wondered about the efficacy of having a simple catch-all script that just tracks everything a user does on the site. I would think it would pound the database relentlessly under even modest load.
- mcos 14y agoYou could read all the responses into a Queue-type structure and then populate the database in the background.
- stevoyoung 14y agoClickish can do this with GA is you wanted. It's also intelligent with how it routes request back to GA. http://www.clickish.org http://www.clickish.org
- darkxanthos 14y agoOne trick is to not use a database but a flat text file. You can optimize for querying nightly.
- ukoki 14y agoAWS comes into its own for these kinds of use cases - make a lightweight autoscaling events API on Elastic Beanstalk pumping events into DynamoDB coupled with a bunch of workers running at the EC2 spot price sorting and processing these into a traditional RDBMS = massively horizontally scalable events handling for pennies an hour.