The W
Views: 98545084
Main | FAQ | Search: Y! / G | Calendar | Color chart | Log in for more!
30.8.14 1337
The W - the-w.com Site Feedback - 2,000,000 pages viewed Register and log in to post!
Pages: 1(1136 newer) Next thread | Previous thread
User
Post (9 total)
Guru Zim
SQL Dejection
Administrator








Since: 9.12.01
From: Bay City, OR

Since last post: 21 days
Last activity: 1 day
AIM:  
#1 Posted on
At some point in the last 30 minutes, Wienerville passed the 2 million pages served mark.

Keep an eye out, and you might be the one to get number 2,000,000 on the views counter in the top left of every page.

(The web server and database are off, and I can't remember why. Trust me, we passed 2 million )

Not bad for under 6 months.



I love it when a plan comes together
Promote this thread!
odessasteps
Scrapple








Since: 2.1.02
From: MD, USA

Since last post: 74 days
Last activity: 40 days
#2 Posted on | Instant Rating: 8.18

only slighty off.

The number as I look at it is: 1,986,824.

Still cool though.



"I get my kicks above the waistline, sunshine." -- Murray Head, One Night in Bangkok
Net Hack Slasher
Banger








Since: 6.1.02
From: Outer reaches of your mind

Since last post: 3535 days
Last activity: 1955 days
#3 Posted on
Right now the number is 1,987,107.

Guru had a "premature" celebration. Don't worry Zim it happens to the best of us. Well except for me


(edited by Net Hack Slasher on 18.6.02 1913)


I don't get it, everyone loves rats, but they don't want to drink the rats milk?
Guru Zim
SQL Dejection
Administrator








Since: 9.12.01
From: Bay City, OR

Since last post: 21 days
Last activity: 1 day
AIM:  
#4 Posted on
No, really, in the logs we ARE over 2,000,000. For some reason, there is a discrepency between the logs and the database.

I'm not sure how the 14,000 page view difference in the database views and log files happened.



I love it when a plan comes together
thecubsfan
Scrapple
Moderator








Since: 10.12.01
From: Aurora, IL

Since last post: 1 day
Last activity: 13 hours
#5 Posted on | Instant Rating: 10.00
Could you have reset the view count on the page for the views before the board was actually open?
Guru Zim
SQL Dejection
Administrator








Since: 9.12.01
From: Bay City, OR

Since last post: 21 days
Last activity: 1 day
AIM:  
#6 Posted on
Well, I suspect that in the logs it is counting pages that partially load but don't get as far as the SQL for updating the views table.

I'm not too worried about it Pick whichever number you want to believe...



I love it when a plan comes together
tarnish
Frankfurter








Since: 13.2.02
From: Back in the Heart of Hali

Since last post: 447 days
Last activity: 6 days
AIM:  
Y!:
#7 Posted on | Instant Rating: 7.46

Aha, now one sees the utility of a database with proper transactions.

Although if the difference between the two numbers has stayed constant, I'd suggest that's not what the issue is.

Are there any static pages on the site? Or were there?

And are you talking Apache logs vs. MySQL logs? Are there any pages that require multiple database accesses?

Or was the database rebuilt at some point?

Or should I just stop spinning my wheels and pretend you never told us your odometers don't agree?

;)



/tarnish...
I'm a disturbed and bitter herb, like salt water and parsley... -- Cleofis Randolph the Patriarch
infinitum
He's got all the keys anyway








Since: 9.12.01
From: Alpha Centauri

Since last post: 3361 days
Last activity: 944 days
AIM:  
ICQ:  
#8 Posted on
It's not a database inconsistency issue.. It's that some PHP pages don't ping the DB to update the stupid "pages viewed" counter, because they exit before getting to that SQL statement (or because they don't call it at all).

The page views Zim are talking about come from the Apache logs, all pages served with extensions html, php, and a few others.

... Adam




People who say that suicide is never the answer just haven't been asking the right questions.
Guru Zim
SQL Dejection
Administrator








Since: 9.12.01
From: Bay City, OR

Since last post: 21 days
Last activity: 1 day
AIM:  
#9 Posted on
Apache logs -v- The views table which is updated via a mysql query as the page is generated.

There shouldn't be any pages on the site that don't call that query, unless.... maybe the FAQ. Still, I doubt there are 14,000 views of the FAQ.

It honestly never really bothered me why they don't match. They are close enough that I don't think either one is seriously flawed.



I love it when a plan comes together
Pages: 1Thread ahead: TheBucsFan - Your #1 Poster
Next thread: Mozilla Question
Previous thread: Show New Only
(1136 newer) Next thread | Previous thread
So close, but the megaclick was claimed by the Spinn3r robot. Closest on either side were thecubsfan (-1) and Spaceman Spiff (+5). Recent millions (and how long it took to get there) 77M 20 Feb 2012 22:44:20 (34:06:12:50) 76M 17 Jan 2012 16:31:30 (34:
Related threads: one MILLION page views... - More...
The W - the-w.com Site Feedback - 2,000,000 pages viewedRegister and log in to post!

The W™ message board

ZimBoard
©2001-2014 Brothers Zim

This old hunk of junk rendered your page in 0.087 seconds.