It is currently Thu Mar 28, 2024 4:54 am

All times are UTC - 8 hours [ DST ]




Post new topic Reply to topic  [ 30 posts ]  Go to page 1, 2  Next
Author Message
Offline
 Post subject: Throttling like displays ( Hypothetically, I mean, ...)
Post #1 Posted: Thu Aug 18, 2011 3:50 pm 
Tengen

Posts: 4380
Location: North Carolina
Liked others: 499
Was liked: 733
Rank: AGA 3k
GD Posts: 65
OGS: Hyperpape 4k
...I have a friend who is kinda vain and can't see where people have liked his posts anymore, because the profile only displays 100 results.

If you want a more "respectable" complaint, you also can't see anything you have liked after the first 100. That's a problem because I often use likes to remember posts that I want to come back to.

_________________
Occupy Babel!


This post by hyperpape was liked by 3 people: Bonobo, daal, shapenaji
Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #2 Posted: Thu Aug 18, 2011 3:56 pm 
Gosei
User avatar

Posts: 2116
Location: Silicon Valley
Liked others: 152
Was liked: 330
Rank: 2d AGA
GD Posts: 1193
KGS: lavalamp
Tygem: imapenguin
IGS: lavalamp
OGS: daniel_the_smith
I wonder if he's related to the guy I know that'd like to be able to sort the gratitude page by likes, or even better, by the post/like ratio... :roll:

_________________
That which can be destroyed by the truth should be.
--
My (sadly neglected, but not forgotten) project: http://dailyjoseki.com


This post by daniel_the_smith was liked by 2 people: Bonobo, daal
Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #3 Posted: Thu Aug 18, 2011 11:19 pm 
Judan
User avatar

Posts: 5539
Location: Banbeck Vale
Liked others: 1103
Was liked: 1456
Rank: 1D AGA
GD Posts: 1512
Kaya handle: Test
In the settings page where that figure can be changed, there's a cryptic warning that there will be a 'slow down' if the number is set over 250. It does not say what, exactly, will slow down. I infer that it is the display of the posts that you have liked, or display of posts in which you have been liked. If so, that seems a reasonable tradeoff. If the whole board slows down, it is not.

I set the number to 200. Please post here if you see any negative effects.

_________________
Help make L19 more organized. Make an index: https://lifein19x19.com/viewtopic.php?f=14&t=5207

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #4 Posted: Sat Aug 20, 2011 2:02 am 
Judan
User avatar

Posts: 5539
Location: Banbeck Vale
Liked others: 1103
Was liked: 1456
Rank: 1D AGA
GD Posts: 1512
Kaya handle: Test
A day or two has passed, and I see no negative effects. I'm going to push it to 300 and see what happens.

EDIT: Neither this particular function nor the board in general seems to have slowed down.

_________________
Help make L19 more organized. Make an index: https://lifein19x19.com/viewtopic.php?f=14&t=5207

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #5 Posted: Wed Aug 31, 2011 7:58 pm 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
Joaz Banbeck wrote:
In the settings page where that figure can be changed, there's a cryptic warning that there will be a 'slow down' if the number is set over 250.

so, I take it that you don't work with sql queries a lot then?

I can imagine that the query for calculating likes could be a very expensive query involving full table scans. And as the size of the database grows, you could potentially lockup the entire system.

for some time now (even before this thread) I've been noticing extreme slow downs, but it now seems to be getting even worse. It usually takes 10-15 seconds to load a page when I first click on a thread title (especially if there are a lot of posts in the thread). Unless you are watching the logs or monitoring the database with a profiler, there's really no way to know if what I'm experiencing is related to your changes or not -- but I would tend to prefer to heed the cryptic warnings, unless you really, really know what you're doing.

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #6 Posted: Wed Aug 31, 2011 8:47 pm 
Gosei
User avatar

Posts: 1744
Liked others: 702
Was liked: 288
KGS: greendemon
Tygem: greendemon
DGS: smaragdaemon
OGS: emeraldemon
i haven't noticed any slowdowns...

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #7 Posted: Wed Aug 31, 2011 10:58 pm 
Oza
User avatar

Posts: 2401
Location: Tokyo, Japan
Liked others: 2338
Was liked: 1332
Rank: Jp 6 dan
KGS: ez4u
I have thought that at times the server has indeed gotten slower recently. I could not say more than that at present as I have not tried to take note of when, what threads I was trying to load, etc. However, it is quite likely that I noticed at least some cases in the Malkovich threads because I load them frequently. They do tend to be long threads.

_________________
Dave Sigaty
"Short-lived are both the praiser and the praised, and rememberer and the remembered..."
- Marcus Aurelius; Meditations, VIII 21

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #8 Posted: Thu Sep 01, 2011 1:50 am 
Judan
User avatar

Posts: 5539
Location: Banbeck Vale
Liked others: 1103
Was liked: 1456
Rank: 1D AGA
GD Posts: 1512
Kaya handle: Test
@Ez4u: Ok, I propose a blind test. Sometime during the month of September I'll set it back to 100 for a 48-hour period. At the end of the month, you tell me when it was.

_________________
Help make L19 more organized. Make an index: https://lifein19x19.com/viewtopic.php?f=14&t=5207

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #9 Posted: Thu Sep 01, 2011 4:35 am 
Oza
User avatar

Posts: 2401
Location: Tokyo, Japan
Liked others: 2338
Was liked: 1332
Rank: Jp 6 dan
KGS: ez4u
Joaz Banbeck wrote:
@Ez4u: Ok, I propose a blind test. Sometime during the month of September I'll set it back to 100 for a 48-hour period. At the end of the month, you tell me when it was.

That does not sound like any fun at all for me. :scratch:

How about this instead, everyone:
1. Every time someone thinks things load too slowly we PM Joaz.
2. Joaz varies the setting and analyzes the complaints to see whether there is a pattern?
That sounds like way more fun from my side. What does everyone else think? :tmbup: ? :tmbdown: ?

_________________
Dave Sigaty
"Short-lived are both the praiser and the praised, and rememberer and the remembered..."
- Marcus Aurelius; Meditations, VIII 21


This post by ez4u was liked by 4 people: Bonobo, daal, speedchase, topazg
Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #10 Posted: Fri Sep 02, 2011 9:37 am 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
Joaz Banbeck wrote:
@Ez4u: Ok, I propose a blind test. Sometime during the month of September I'll set it back to 100 for a 48-hour period. At the end of the month, you tell me when it was.

Wow, its extremely zippy this morning -- pages loading in milliseconds, instead of 10's of seconds. (just in case something was changed already)

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #11 Posted: Fri Sep 02, 2011 10:57 am 
Oza
User avatar

Posts: 2644
Liked others: 304
Was liked: 631
Rank: kgs 6k
xed_over wrote:
Joaz Banbeck wrote:
@Ez4u: Ok, I propose a blind test. Sometime during the month of September I'll set it back to 100 for a 48-hour period. At the end of the month, you tell me when it was.

Wow, its extremely zippy this morning -- pages loading in milliseconds, instead of 10's of seconds. (just in case something was changed already)

I notice no change. What browser do you use?

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #12 Posted: Fri Sep 02, 2011 6:20 pm 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
jts wrote:
I notice no change. What browser do you use?

Firefox/Mac mostly.

This is night and day different from 2 days ago -- a long thread page would take 15-20 seconds to load (I timed them) each time. Now the same threads load instantaneously (mere milliseconds).

I don't know what, if anything changed, but its much, much better now.

At first I half suspected our corporate network at work, but I got the same behavior on my home network. Besides, no other sites ever behaved the same as this site.

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #13 Posted: Fri Sep 02, 2011 8:32 pm 
Judan
User avatar

Posts: 5539
Location: Banbeck Vale
Liked others: 1103
Was liked: 1456
Rank: 1D AGA
GD Posts: 1512
Kaya handle: Test
I haven't changed anything yet. :-?

_________________
Help make L19 more organized. Make an index: https://lifein19x19.com/viewtopic.php?f=14&t=5207

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #14 Posted: Fri Sep 02, 2011 8:48 pm 
Oza
User avatar

Posts: 2644
Liked others: 304
Was liked: 631
Rank: kgs 6k
I've been using Chrome on XP and have had blistering fast load times for as long as I can remember.

(Or at least I should say, the page loads immediately. Sometimes if there are 20+ diagrams, it takes them a while to load, but I assume that's not what you mean.)

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #15 Posted: Sat Sep 03, 2011 2:35 pm 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
Joaz Banbeck wrote:
I haven't changed anything yet. :-?

well, that's unfortunate. something clearly changed for me. there are so many links in the chain, so its really very difficult debug things like this. for all we know, maybe the L19 hosting company rebooted their sql server.

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #16 Posted: Sat Sep 03, 2011 10:16 pm 
Gosei
User avatar

Posts: 1758
Liked others: 378
Was liked: 375
Rank: 4d
Wouldn't the easiest way to test this just be to crank it up to a large number (like 1000) during off-peak hours and see if there's a noticeable slowdown? If there is, revert; otherwise, we're fine.

_________________
We don't know who we are; we don't know where we are.
Each of us woke up one moment and here we were in the darkness.
We're nameless things with no memory; no knowledge of what went before,
No understanding of what is now, no knowledge of what will be.

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #17 Posted: Sat Sep 03, 2011 11:08 pm 
Judan
User avatar

Posts: 5539
Location: Banbeck Vale
Liked others: 1103
Was liked: 1456
Rank: 1D AGA
GD Posts: 1512
Kaya handle: Test
Dusk Eagle wrote:
Wouldn't the easiest way to test this just be to crank it up to a large number (like 1000) during off-peak hours and see if there's a noticeable slowdown? If there is, revert; otherwise, we're fine.



If I understand how it works, I don't think that doing that would tell us anything. The amount of work done under the current 300 cap should be the same as the work done under a 1000 cap, for nobody has 300+ liked posts. A handful of people have 300 or more likes, but they are never distributed 1 per post.
For example, among the heavy contributors, Araban has 392 likes on 277 unique posts; I have 304 likes on 187 unique posts. John Fairbairn, the most liked poster on L19, has crowded his 796 likes into only 230 unique posts.

I may be wrong about it, but that is my current understanding.

_________________
Help make L19 more organized. Make an index: https://lifein19x19.com/viewtopic.php?f=14&t=5207

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #18 Posted: Sun Sep 04, 2011 6:25 am 
Gosei
User avatar

Posts: 1758
Liked others: 378
Was liked: 375
Rank: 4d
Quote:
...for nobody has 300+ liked posts.

Yeah, I didn't check for that.

_________________
We don't know who we are; we don't know where we are.
Each of us woke up one moment and here we were in the darkness.
We're nameless things with no memory; no knowledge of what went before,
No understanding of what is now, no knowledge of what will be.

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #19 Posted: Mon Sep 05, 2011 4:33 pm 
Judan
User avatar

Posts: 5539
Location: Banbeck Vale
Liked others: 1103
Was liked: 1456
Rank: 1D AGA
GD Posts: 1512
Kaya handle: Test
Dusk Eagle wrote:
Quote:
...for nobody has 300+ liked posts.

Yeah, I didn't check for that.


But your idea will come in useful eventually. We'll try it in a year or two, when someone gets to 500+ liked posts.

_________________
Help make L19 more organized. Make an index: https://lifein19x19.com/viewtopic.php?f=14&t=5207

Top
 Profile  
 
Offline
 Post subject: Re: Hypothetically, I mean, I have a friend who is...
Post #20 Posted: Fri Sep 16, 2011 2:42 am 
Oza

Posts: 2264
Liked others: 1180
Was liked: 552
xed_over wrote:
Joaz Banbeck wrote:
I haven't changed anything yet. :-?

well, that's unfortunate. something clearly changed for me. there are so many links in the chain, so its really very difficult debug things like this. for all we know, maybe the L19 hosting company rebooted their sql server.

this is probably the wrong thread for this, since apparently my issue no longer appears to be related to the change mentioned in the initial topic of this thread...

long threads are taking longer to render/load again. I started noticing it at least a few days ago.

Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 30 posts ]  Go to page 1, 2  Next

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group