My site doesn't have quite as many pages (it's 95% php/mysql driven, so ALL content is created dynamically), but I've setup a small counter.
However, my implementation is a bit more basic and thus might not necessarily apply here. I'm not sure. I think it's an extremely fast way of doing it. Though I suppose you can't get much slower than working with a flat-file?
Basically, I have fields setup in my table for each page I want to rack:
CREATE TABLE stats (stats_id int not null primary key auto_increment, page1 int, page2 int....);
Perhaps you might want to use BIGINT? Never used it, not sure about the diff (I'm still quite new to php/mysql), but with those kinds of views....
Then, the rest is quite simple:
On each page that you want to track, you write the corresponding page name and include("stats_counter.php"); as such:
In Page1.php:
<?
$page = "page1";
include("stats_counter.php");
?>
...rest of html
stats_counter.php:
<?
$stats_result = mysql_query("SELECT $page FROM stats");
$stats = mysql_fetch_row($stats_result);
$counter = ++$stats[0];
mysql_query("UPDATE stats SET $page='$counter'");
?>
That should be it.
A bit too simple perhaps? It perhaps won't give you as much detailed info as you want, and with the # of pages you're dealing with, perhaps you'll want to incorporate some kind of auto-field insertion. Furthermore, it's not really a hit-tracker, so much as a page-views counter. Not sure which you were looking for.
Personally, I'd reckon that the simpler the better, but perhaps you need more detailed info.
Pardon if this was too much in the wrong direction.
