Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


kenkeniff

628 posts

Ultimate Geek


#150942 8-Aug-2014 12:24
Send private message

Registered users at least would be nice.

"Eventual consistency" even would be ok.

Dumb increments (counts F5) would be better than nothing (seems to work for TradeMe lol). 

Please. 

View this topic in a long page with up to 500 replies per page Create new topic
 1 | 2
Coil
6614 posts

Uber Geek
Inactive user


  #1104823 8-Aug-2014 12:25
Send private message

Lol, Good old mash F5 trademe. I setup a few VM's and let them run overnight refreshing 5 times a second and lol. had close to 2 million views by the morning.



kenkeniff

628 posts

Ultimate Geek


  #1104827 8-Aug-2014 12:33
Send private message

TimA: Lol, Good old mash F5 trademe. I setup a few VM's and let them run overnight refreshing 5 times a second and lol. had close to 2 million views by the morning.


Doh, that's not going to fill freitasm with confidence..

freitasm
BDFL - Memuneh
79250 posts

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #1104834 8-Aug-2014 12:48
Send private message

One of the reasons I removed it was for speed - less database updates, especially in very busy threads.

Not seeing it coming back yet. I am tweaking with the idea of changing something in our database to improve performance, might come back then.





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup




gzt

gzt
17104 posts

Uber Geek

Lifetime subscriber

  #1104837 8-Aug-2014 12:52
Send private message

I have to admit being morbidly curious about the reason for removing the feature (long ago). Was it commercial sensitivity?

Edit: Posted this prior to above post arriving. I consider it answered.

freitasm
BDFL - Memuneh
79250 posts

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #1104838 8-Aug-2014 12:53
Send private message

Nope, purely database performance (index locks, row locks, etc).





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


kenkeniff

628 posts

Ultimate Geek


  #1104840 8-Aug-2014 12:54
Send private message

freitasm: One of the reasons I removed it was for speed - less database updates, especially in very busy threads.

Not seeing it coming back yet. I am tweaking with the idea of changing something in our database to improve performance, might come back then.



Is it database I/O or specific row/table locking you're concerned about (hence the latter I suggested eventual consistency so don't need to queue up write locks on a single row/table)?

EDIT: Saw your post above. In that case eventual consistency by writing views to cache then lazily updating a main counter will solve this (the Youtube's etc do this).

freitasm
BDFL - Memuneh
79250 posts

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #1104846 8-Aug-2014 13:10
Send private message

Not I/O, but locking strategy. We currently have very low number of I/O interruptions because almost the entire database is in memory. Transactrion Log is the one thing that consumes I/O mostly, so not a big deal.

We did change to READ COMMITTED SNAPSHOT a while back to improve locking speed and prevent waits.





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


 
 
 

Cloud spending continues to surge globally, but most organisations haven’t made the changes necessary to maximise the value and cost-efficiency benefits of their cloud investments. Download the whitepaper From Overspend to Advantage now.

gzt

gzt
17104 posts

Uber Geek

Lifetime subscriber

  #1104859 8-Aug-2014 13:31
Send private message

freitasm: One of the reasons I removed it was for speed - less database updates, especially in very busy threads.

Would maintaining count only for registered user views be any more feasible in that regard?

freitasm
BDFL - Memuneh
79250 posts

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #1104867 8-Aug-2014 13:43
Send private message

Would be terrible undercounted. The number of visits from non-registered or non-logged in users is much bigger.





Please support Geekzone by subscribing, or using one of our referral links: Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSyncBackblaze backup


kenkeniff

628 posts

Ultimate Geek


  #1104870 8-Aug-2014 13:45
Send private message

freitasm: Would be terrible undercounted. The number of visits from non-registered or non-logged in users is much bigger.



Still useful though.

Thread XYZ (999 Registered Views, 0 Replies)

gzt

gzt
17104 posts

Uber Geek

Lifetime subscriber

  #1104874 8-Aug-2014 13:52
Send private message

I agree, but it would give good indication of community/interest engagement. If counting the other group becomes possible that can be added also. The two figures are complementary and both give useful information.

MikeB4
18435 posts

Uber Geek

ID Verified
Trusted

  #1104891 8-Aug-2014 14:23
Send private message

The last (big) forum I was Admin for we did away with page views as the hit on performance was such it did not justify keeping for very little benefit, we did away with it.

kenkeniff

628 posts

Ultimate Geek


  #1104892 8-Aug-2014 14:27
Send private message

KiwiNZ: The last (big) forum I was Admin for we did away with page views as the hit on performance was such it did not justify keeping for very little benefit, we did away with it.


Cool story, neither assumption applies here

MikeB4
18435 posts

Uber Geek

ID Verified
Trusted

  #1104912 8-Aug-2014 14:48
Send private message

kenkeniff:
KiwiNZ: The last (big) forum I was Admin for we did away with page views as the hit on performance was such it did not justify keeping for very little benefit, we did away with it.


Cool story, neither assumption applies here


It doesn't ?

gzt

gzt
17104 posts

Uber Geek

Lifetime subscriber

  #1104923 8-Aug-2014 15:05
Send private message

KiwiNZ:
kenkeniff:
KiwiNZ: The last (big) forum I was Admin for we did away with page views as the hit on performance was such it did not justify keeping for very little benefit, we did away with it.


Cool story, neither assumption applies here


It doesn't ?

It was exactly the reason freitasm removed it, so it seems a similar performance experience applies.

Please guys don't start a he said/i said and derail the thread. Just leave it there please.

 1 | 2
View this topic in a long page with up to 500 replies per page Create new topic





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.