Quote:
Originally Posted by TACNet
For scaleablitiy, I'd be careful about writing your data directly to your MySql tables
We had the same issue when putting together our affiliate tracking scripts. It only takes one bot to start hammering your pages and it will down your DB server
We found a far better approach is to write everything to a log file first and then setup a cron script to process that log file every 15 minutes or whatever. That way you can filter out duplicates, bot scripts etc etc
Hope that helps
|
I sent million hits in single day to my tracking script and there was no issue at all. Tho, i have delayed processing so that help. But your approach is good as well, it's like crude cache system.