User Post (9 total)
Guru Zim SQL Dejection Administrator Level: 137 Posts: 803/5949 EXP: 30693856 For next: 179077 Since: 9.12.01 From: Bay City, OR Since last post: 12 hours Last activity: 11 hours
AIM: # 1 Posted on 18.6.02 1656.14 Reposted on: 18.6.09 1657.41 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. Promote this thread!
odessasteps Scrapple Level: 128 Posts: 655/5052 EXP: 23955925 For next: 425841 Since: 2.1.02 From: MD, USA Since last post: 1 day Last activity: 9 min. # 2 Posted on 18.6.02 1752.34 Reposted on: 18.6.09 1754.33 only slighty off. The number as I look at it is: 1,986,824. Still cool though.
Net Hack Slasher Banger Level: 99 Posts: 252/2805 EXP: 9906539 For next: 93496 Since: 6.1.02 From: Outer reaches of your mind Since last post: 3363 days Last activity: 1783 days # 3 Posted on 18.6.02 1813.01 Reposted on: 18.6.09 1813.03 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)
Guru Zim SQL Dejection Administrator Level: 137 Posts: 804/5949 EXP: 30693856 For next: 179077 Since: 9.12.01 From: Bay City, OR Since last post: 12 hours Last activity: 11 hours
AIM: # 4 Posted on 18.6.02 1907.48 Reposted on: 18.6.09 1908.13 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.
thecubsfan Scrapple Moderator Level: 127 Posts: 218/4937 EXP: 23202517 For next: 524114 Since: 10.12.01 From: Aurora, IL Since last post: 13 hours Last activity: 2 hours # 5 Posted on 18.6.02 1944.36 Reposted on: 18.6.09 1945.26 Could you have reset the view count on the page for the views before the board was actually open?
Guru Zim SQL Dejection Administrator Level: 137 Posts: 808/5949 EXP: 30693856 For next: 179077 Since: 9.12.01 From: Bay City, OR Since last post: 12 hours Last activity: 11 hours
AIM: # 6 Posted on 18.6.02 1951.36 Reposted on: 18.6.09 1951.46 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...
tarnish Frankfurter Level: 59 Posts: 131/859 EXP: 1671727 For next: 1411 Since: 13.2.02 From: Back in the Heart of Hali Since last post: 275 days Last activity: 13 hours
Y!: # 7 Posted on 18.6.02 2033.30 Reposted on: 18.6.09 2034.09 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? ;)
infinitum He's got all the keys anyway Level: 17 Posts: 17/46 EXP: 20869 For next: 3874 Since: 9.12.01 From: Alpha Centauri Since last post: 3188 days Last activity: 772 days
ICQ: # 8 Posted on 18.6.02 2046.24 Reposted on: 18.6.09 2046.42 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
Guru Zim SQL Dejection Administrator Level: 137 Posts: 810/5949 EXP: 30693856 For next: 179077 Since: 9.12.01 From: Bay City, OR Since last post: 12 hours Last activity: 11 hours
AIM: # 9 Posted on 18.6.02 2047.55 Reposted on: 18.6.09 2059.01 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.
ALL ORIGINAL POSTS IN THIS THREAD ARE NOW AVAILABLE
The W message board - 7 year recycle ZimBoard ©2001-2014 Brothers Zim This old hunk of junk rendered your page in 0.171 seconds.