Menu
Community /Pin to ProfileBookmark
@NogDogNov 04.2014 — #Firstly, don't underestimate the efficiency of a properly designed and indexed database. I work on a project with one DB table that has over 80,000,000 rows, and it gets joined on by all the most common requests to that system. Granted, you're looking more at inserts than selects, but that should not be a major difference versus writing to a file.
That being said, is the info you need already available in the HTTP logs (and do you have access to them)? If so, maybe some sort of cron job that periodically (nightly?) parses them for the data of interest and updates a database (or text file?) with the counts of interest could serve your purposes. (Could be a good time to learnAwk .)@NogDogNov 05.2014 — #As long as it's in the URL (i.e. a GET request), it would part of the HTTP logs, should that route interest you; but if you can control it directly from the application, that's probably more robust and flexible. (Hey, if you get so much traffic that it becomes an issue, then buying additional servers should be a minor issue. ? )
Just a thought, you could put the logging stuff into a separate PHP file, and have it called before any PHP page runs via the[url=http://php.net/manual/en/ini.core.php#ini.auto-prepend-file]auto_prepend_file[/url] configuration directive, then you wouldn't even have to bother adding include/require statements to your existing scripts.
Efficient way to log page impressions?
I’ve been working on my affiliate program for my software, and I’ve finally finished it, now I’m working on the dashboard.
I decided that I wanted to add impression statistics to the dashboard (Amount of page views).
The way I thought about doing this was saving a row into a database every-time the page was loaded, with a key-value of the affiliates user-name, and then the date.
This would definitely work, and do what I want it to, however this would populate the databases ridiculously quickly.
I will have to store the impression data for three months, and if a single affiliate is generating 1,000 impressions per day, that’s 1,000 rows in the database, seems highly inefficient.
What do you guys recommend as an efficient way to do this?
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogNov 04.2014 — #Firstly, don't underestimate the efficiency of a properly designed and indexed database. I work on a project with one DB table that has over 80,000,000 rows, and it gets joined on by all the most common requests to that system. Granted, you're looking more at inserts than selects, but that should not be a major difference versus writing to a file.That being said, is the info you need already available in the HTTP logs (and do you have access to them)? If so, maybe some sort of cron job that periodically (nightly?) parses them for the data of interest and updates a database (or text file?) with the counts of interest could serve your purposes. (Could be a good time to learn
0
@NogDogNov 05.2014 — #As long as it's in the URL (i.e. a GET request), it would part of the HTTP logs, should that route interest you; but if you can control it directly from the application, that's probably more robust and flexible. (Hey, if you get so much traffic that it becomes an issue, then buying additional servers should be a minor issue. ? )Just a thought, you could put the logging stuff into a separate PHP file, and have it called before any PHP page runs via the