The Lightest Hit Counter Ever...

They have: 330 posts

Joined: Apr 2000

I'm sorry if you came here because you thought I created one. Actually I'm looking for one.

I am making an internal website which will have over 300 pages built into it as reference material. One of the requests during the creation process is to add a counter in the background so we can see how many times each page is hit.

The site is primarily ASP and I know I could use an Access DB to make a hit counter. I am just hoping someone else has a better way to making this easier on the server. Here are my concerns.

1. There will be about 300 pages in this application but soon will have over 1200 using the same format.

2. At any time there will be up to 180-200 people accessing these applications.

3. Openning a DB this many times will eventually take a toll on the servers which I would assume will result in crashes or at least freezes.

Thanks for any help.

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Maybe its time to consider moving to SQL Server? You could also save these stats to an XML or text file but my first choice would be SQL Server.

With a busy site spreading the load over 2 or more servers is a good habit to get into (WEB/ASP on one, and DB on another)

Access will probably barf on record locking problems with so many users.

PJ | Are we there yet?
pjboettcher.com

They have: 601 posts

Joined: Nov 2001

Why don't you just analyze your log files instead? If that's all you need is the number of page hits each page is getting then your log files are more than likely doing this already. All you would need then is to analze them - run an analyzer program at the quier periods around your site, or run it off your log files on a completly seperate machine if you're after zero overheads. Have you looked into Analog? => http://www.analog.cx

- wil

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.