Welcome! Log In Create A New Profile

Advanced

Re: The Lily = NGDF = My Opinion

November 09, 2018 09:24PM
While I definitely see Roger's point, as I responded to his email, view counters are brutal on overall performance. Every time somebody hits a page it has to go update records to track those views. Databases are typically optimized either for read access where the number of reads swamp the number of writes, or for write access where you need to do lots of updates but very few queries. It's very difficult to make a database do both well without some serious design and serious iron backing it up. NGDF, and most internet sites, are the former - lots of reads, few writes. Plus, since the data is fairly static, caching works very well and we can usually skip the database query entirely. If you have view counters on, the cache goes to hell and you have to do the DB query every single time. Pretty much every guide to setting up Phorum (the BB software that runs NGDF) will tell you that view counters are one of your top performance gremlins.

Don and I had view counters on at several points in the past, and had to disable them because they were just killing performance as our number of users and visitors continued to grow. That was several years back, and our page views have skyrocketed since then.

I told Roger he's more than welcome to post links if he wants to send visitors to his own site so that he has metrics on the number of views. I appreciate his posts and enjoy looking at them, as do most of us, and I certainly don't want anyone to be of the opinion that I'm discouraging his posts. I Unfortunately his request just isn't one I can accommodate right now, because at the moment it's a trade-off, and I'm prioritizing good overall performance over view counters. Until such point that NGDF moves onto bigger hardware (and that's not going to happen until my life is a little less under water, maybe in a year or so), enabling them just isn't an option.
Subject Author Posted

The Lily = NGDF = My Opinion

Roger Hogan November 08, 2018 09:46AM

Re: The Lily = NGDF = My Opinion

Dave Peterson November 08, 2018 11:30AM

Re: The Lily = NGDF = Opinion . . . thumbs upthumbs up

Russo Loco November 08, 2018 11:40AM

Re: The Lily = NGDF = My Opinion

Jason Rose November 08, 2018 12:12PM

Counters = Example

Roger Hogan November 08, 2018 01:46PM

Re: Counters = Example

rockrdg November 08, 2018 01:59PM

Re: Counters = Example

Roger Hogan November 08, 2018 02:07PM

Re: Counters = Example

Russo Loco November 08, 2018 02:34PM

Re: Counters = Example

rockrdg November 08, 2018 02:53PM

Re: Counters = Example

Roger Hogan November 08, 2018 05:12PM

Re: Counters = Example Attachments

Dirk Ramsey November 08, 2018 08:15PM

Re: Counters = Example

Popeye8762 November 08, 2018 07:08PM

Re: The Lily = NGDF = My Opinion

Tomstp November 08, 2018 01:51PM

Re: The Lily = NGDF = My Opinion

Jason Rose November 08, 2018 01:55PM

Re: The Lily = NGDF = My Opinion

CharlieMcCandless November 08, 2018 02:04PM

Re: The Lily = NGDF = My Opinion

Dutch Flat November 08, 2018 02:18PM

Re: The Lily = NGDF = My Opinion

James November 08, 2018 02:37PM

Re: The Lily = NGDF = Another Opinion . . . smileys with beer

Russo Loco November 08, 2018 04:52PM

Re: The Lily = NGDF = Another Opinion . . . smileys with beer Attachments

Dirk Ramsey November 08, 2018 08:36PM

Re: The Lily = NGDF = Another Opinion . . . smileys with beer

Chris Walker November 08, 2018 11:29PM

Re: The Lily = NGDF = Another Opinion . . . smileys with beer Attachments

Dirk Ramsey November 09, 2018 08:59PM

Re: The Lily = NGDF = Another Opinion . . . smileys with beer

Wayne Hoskin November 09, 2018 09:12PM

Re: The Lily = NGDF = Another Opinion . . . smileys with beer

Dirk Ramsey November 09, 2018 11:10PM

Re: The Lily = NGDF = My Opinion

hank November 08, 2018 06:59PM

deleted

Brian Norden November 08, 2018 07:15PM

Re: The Lily = NGDF = My Opinion

MSRRKevin November 08, 2018 08:19PM

Re: The Lily = NGDF = My Opinion

hamman523 November 08, 2018 08:58PM

Re: The Lily = NGDF = My Opinion

Roger Hogan November 09, 2018 01:20PM

Re: The Lily = NGDF = My Opinion

Wayne Hoskin November 09, 2018 04:47PM

Re: The Lily = NGDF = My Opinion

Roger Hogan November 09, 2018 05:36PM

Re: The Lily = NGDF = My Opinion

ND Holmes November 09, 2018 09:24PM

Re: The Lily = NGDF = My Opinion

Roger Hogan November 10, 2018 06:19AM



Sorry, only registered users may post in this forum.

Click here to login