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...
| Life In 19x19 http://lifein19x19.com/ |
|
| Throttling like displays ( Hypothetically, I mean, ...) http://lifein19x19.com/viewtopic.php?f=14&t=4494 |
Page 1 of 2 |
| Author: | hyperpape [ Thu Aug 18, 2011 3:50 pm ] |
| Post subject: | Throttling like displays ( Hypothetically, I mean, ...) |
...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. |
|
| Author: | daniel_the_smith [ Thu Aug 18, 2011 3:56 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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...
|
|
| Author: | Joaz Banbeck [ Thu Aug 18, 2011 11:19 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | Joaz Banbeck [ Sat Aug 20, 2011 2:02 am ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | xed_over [ Wed Aug 31, 2011 7:58 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | emeraldemon [ Wed Aug 31, 2011 8:47 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
i haven't noticed any slowdowns... |
|
| Author: | ez4u [ Wed Aug 31, 2011 10:58 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | Joaz Banbeck [ Thu Sep 01, 2011 1:50 am ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
@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. |
|
| Author: | ez4u [ Thu Sep 01, 2011 4:35 am ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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.  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?  ?  ?
|
|
| Author: | xed_over [ Fri Sep 02, 2011 9:37 am ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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) |
|
| Author: | jts [ Fri Sep 02, 2011 10:57 am ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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? |
|
| Author: | xed_over [ Fri Sep 02, 2011 6:20 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | Joaz Banbeck [ Fri Sep 02, 2011 8:32 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
I haven't changed anything yet. 
|
|
| Author: | jts [ Fri Sep 02, 2011 8:48 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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.) |
|
| Author: | xed_over [ Sat Sep 03, 2011 2:35 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | Dusk Eagle [ Sat Sep 03, 2011 10:16 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | Joaz Banbeck [ Sat Sep 03, 2011 11:08 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | Dusk Eagle [ Sun Sep 04, 2011 6:25 am ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
Quote: ...for nobody has 300+ liked posts. Yeah, I didn't check for that. |
|
| Author: | Joaz Banbeck [ Mon Sep 05, 2011 4:33 pm ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Author: | xed_over [ Fri Sep 16, 2011 2:42 am ] |
| Post subject: | Re: Hypothetically, I mean, I have a friend who is... |
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. |
|
| Page 1 of 2 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|