The Lightest Hit Counter Ever...
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 posted this at 15:02 — 28th December 2001.
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
Wil posted this at 11:44 — 3rd January 2002.
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.