I am noticing that the list of earned bounties loads noticeably slower when the user has more than 10ish bounties! The same slowness is noticed by activating the earned link on the list of bounties in the Summary tab. The effect can be seen whether logged in or not.

Here's some visual feedback from Chrome's Developer Tools as to the differences between one and the other.

Without showing earned bounties: Profile speed without showing earned bounties

Showing earned bounties: Profile speed showing earned bounties


As you can see, there's a whopping 4 seconds difference during page request! I don't think this is critical, but it seems like it may be putting additional stress somewhere (other than cache).


UPDATE 2013-05-13: It's happening again. In contrast, the same does not happen here on MSO.

Here's a new screenshot:

Reoccurring Profile Speed Issues

share|improve this question
    
I cannot reproduce this, are you still seeing slowness? If so it could be a non-mod view of the query in which case I need to dig deeper. –  Nick Craver Apr 22 '13 at 23:14
    
@Nick It looks like somebody fixed something. It's working blazingly fast now. It had been working slow for upwards of two weeks (don't know about before that), if I recall correctly. There must've been some update on the earned bounties query recently. –  Jesse Apr 22 '13 at 23:15
    
nope nothing there, may have been a bad plan for that I cleared out with a batch a few days ago though. –  Nick Craver Apr 23 '13 at 0:40
add comment

1 Answer

up vote 5 down vote accepted

This was likely a bad query plan, one of several nuked from the plan cache over the past few days - if the issue returns let me know and I'll take another look at how the parameterization is behaving here.

share|improve this answer
    
Sounds like a plan! I'll add a comment to this answer if I see it again. –  Jesse Apr 23 '13 at 1:37
1  
It's happening again. I've also unmarked your answer to try to draw your attention. =) –  Jesse May 13 '13 at 19:09
    
I see it too, with for example this user: stackoverflow.com/users/712765/… (takes up to 6sec to load) –  cheesemacfly May 14 '13 at 17:53
1  
@cheesemacfly try now...I've nuked that plan from cache and noted what needs changing, but nuking it is the best I can do from an ipad on a plane. I'll make the necessary query option changes once I land. –  Nick Craver May 14 '13 at 18:17
    
@NickCraver It's still happening. –  Jesse May 14 '13 at 18:24
    
@NickCraver still happening...sorry –  cheesemacfly May 14 '13 at 20:14
    
@NickCraver Any resolution to this? –  Jesse May 16 '13 at 13:08
    
@Jesse - sorry, we're all over the place at google i/o this week...can you give it a go now? I've pushed a query option change that should prevent the bad plan in the future –  Nick Craver May 16 '13 at 14:13
    
@NickCraver No worries. It's still slow, however. –  Jesse May 16 '13 at 14:49
    
@Jesse which URL are you trying? I'm unable to get over a 100ms page load here no matter who I hit, logged in or our (moderators get a different query) –  Nick Craver May 16 '13 at 17:04
    
@NickCraver I'm testing the original set in the question: 1 2 3 4 5. I've even tried different connections (direct and proxy). Can I do anything differently that will yield better logging/stats to help you? –  Jesse May 16 '13 at 19:41
    
@NickCraver For what it's worth - it's working fast again. Hopefully you found the issue. –  Jesse May 18 '13 at 2:15
    
@NickCraver Works fast again here too! –  cheesemacfly May 19 '13 at 1:50
add comment

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .