|
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
__________________
TAC Amateurs - The World's LARGEST Amateur Porn Network
|