What's happened with our page views? , page 1
Pages: <<  1    2    3    4  >>
ATS Members have flagged this thread 42 times


reply posted on 16-10-2008 @ 03:52 AM by HypnoAsp
I Concur.........................................










~Hyp



reply posted on 16-10-2008 @ 05:37 AM by Syndular
Originally posted by SkepticOverlord
The views tally has been disabled, possibly permanently.


We are exceptionally unique as far as "discussion boards" go. More than 80% (sometimes up to 90%) of all our daily traffic is from non-members. And during the month of October, we've been averaging about 100,000 visits a day, with an average page-views (of content pages) over 550,000 daily. That's a crap-load of activity.

Incrementing the views counter requires a write action to the database on every one of those page-loads. And as any database administrator will tell you, write (updates) are the most intensive tasks. We were experiencing some performance issues, and once we disabled the views-tally, the issues were cleared up.

So it's the constant balancing act of ensuring all our content is available in a fast and efficient way, along with a long list of unique services for members.



And for those keeping track who might say, "just get a bigger database server,"... we're at the upper-limit of what is available to anyone who leases machines from enterprise-class server providers (a 16-core db server with 32 GB RAM). We've been reviewing options to move to a cluster of db servers, but it requires purchasing some rather costly hardware, which is beyond our current means.


Good post, maybe make it a sticky? Close it so we don't have to listen to others endless cries also. Unless this info is already a sticky but either way... good info. Thanks!


reply posted on 16-10-2008 @ 08:14 AM by badmedia
reply to post by Quantum_Squirrel



The only solution is what I mentioned, and that is writing the entires to a smaller table, and then transferring the totals over every few hours. If there is alot of traffic, then you can just append to the end of a log file, and parse those into the table every few hours as well, then you have 0 database writes.

I can already hear the people crying about view manipulations just like they do with YouTube because they won't update instantly.

Every time you write to a table, it locks the row(entry) you are updating. Given the amount of threads and size of these forums, with the traffic he is talking about, there is no question it's eating up a ton of resources.

I like stats, so I personally hope they do the solution.


reply posted on 16-10-2008 @ 08:26 AM by justregistered
reply to post by SkepticOverlord



You really are rocking with 100,000 visits a day. If it's going up day by day, you should show the progress to the users. Probably not in details but in %.


reply posted on 16-10-2008 @ 10:05 AM by TruthTellist
reply to post by badmedia



Yes, but what if they would no longer count page views after 1000?

Wouldn't that work?


reply posted on 16-10-2008 @ 10:31 AM by TheWayISeeIt
reply to post by SkepticOverlord



You should just get rid of all references to page views all over the site, i.e Profile page Recent Threads, so the 0 views isn't sitting there taunting the number minded.

What happened to the tagging mechanism? It's been gone since before the new site launch, is that over? Need we not concern ourselves with that anymore?

BTW, the new site design is fantastic.
Pages: <<  1    2    3    4  >>    ^^TOP^^



Did Carl Sagan know something?
  Posted 17 days ago with 276 member flags
Earthly coincidences...or not.
  Posted 13 days ago with 122 member flags
STOP....Take a STEP BACK....and look at the BIG PICTURE!!
  Posted 19 days ago with 115 member flags
Was this the real reason why Megaupload was closed down?
  Posted 17 days ago with 96 member flags
The Mysterious Death of Marilyn Monroe
  Posted 15 days ago with 85 member flags