Quote:
Originally Posted by http
One of these days I want to start recording the amount of hits I send to every single sponsor site.
Who's doing this and how? I figure writing it to a mysql table uses a lot of CPU / RAM?
|
You would need to pass all links through your own script which will "redirect" the user to the other site.
Quote:
Originally Posted by http
If I sent 100K hits a day to 200 sites, would I run 100K mysql update queries on a table with the 200 sites?
|
Yes, but 100K queries every 24 hours is only 1.157 per second, regardless of how many sites these 100k hits are being sent to. 100k is a big number for people, but very miniscule to a server... unless you're running like a 8086 with 1mb of ram.
Quote:
Originally Posted by http
Won't that tear down my server? Is there a more elegant way to do this, i.e. write to a text file first or whatever?
|
Using a flat file as a database for this would actually be a step backwards in "elegance".