question

WilliamD avatar image
WilliamD asked

[meta] Performance of ASK (esp. karma history)

I just got a quick question here about your perceived performance of ASK in regard to load times. I am running IE 8 on a WIN 7 64 bit machine and notice some parts of ASK performing quite slowly. The major area that is slow for me is the karma history. This is slow, especially so for people with high karma - I'm looking at you Matt! ;o). It seems that at around 3000 rep. the graph for karma builds *really* slow and gets worse as you get higher (as of 2010-09-16 it takes 15 seconds to load Matt's history @ rep. of 16471). I imagine this problem is twofold - first to get the data, second to render it. Does anyone else see this happening? If so, maybe we can do some database performance tuning for OSQA (is it SQL Server?), obviously if it is the renderer someone other than myself would need to take a look.
meta-askssc
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
I think the database engine has been mentioned before and, although to my knowledge it hasnt been confirmed, its an open source site so we suspect its an open source solution in the db department too
0 Likes 0 ·
hernani avatar image hernani commented ·
Postgres is the db engine which competes in the enterprise department, even though it is an open source project, but see my answer to see the real problem.
0 Likes 0 ·
hernani avatar image
hernani answered
The problem is known, and is related with the script that renders the graph, which btw, is [flot][1]. Even in IE8 you can get better times if you toggle compatibility view. Please see here . [1]: http://code.google.com/p/flot/
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
Thanks for the info!
0 Likes 0 ·
Oleg avatar image Oleg commented ·
Since the source code on this site gets updated sometimes, it takes to occasionally hit **Ctrl+F5** to clear stale cache. From what I see, performance of karma hitory is affected only by the graph. One of the problems which can be seen with the naked eye is the scaling of the dots. Usually, the graphs (probably not this one though) are internally implemented to change the scale once the period of time increases. For example, to plot one month worth of data, the graph chooses every point of its respective source. To plot 1 year worth of data, the graph auto-averages (or simply disregards) daily points and uses weekly data and smoothes the line. Since the graph belongs to Google, it is not fair to compare IE and Chrome performance, because the code is specifically written to slow down IE by faking unsupported canvas with javascript emulation. To me it does not matter, I will never have Chrome anywhere near my computers (I like my privacy and Chrome is a bit too invasive for me to tolerate). The first time I started using Microsoft't .NET chart, which is free, clean, includes a bunch of financials, has just as small footprint as Dundas (has rounded corners too), I need nothing else :)
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Just loaded Matt's karma history - under 2 seconds. Chrome on XP.
11 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
So basically IE8/IEn = FAIL!
1 Like 1 ·
Cyborg avatar image Cyborg commented ·
for me also it loaded under 1 Second on Chrome on XP
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
So maybe it is just me. I'll try it on another machine a little later.
0 Likes 0 ·
Cyborg avatar image Cyborg commented ·
I tested it on IE8, it took over 20 Sec. May be the problem with IE7?
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
If I download the karma history page for Matt we are talking about 75Kb, so it can't really be data. It must be the rendering of the graph that just sucks in IE8 then
0 Likes 0 ·
Show more comments
Matt Whitfield avatar image
Matt Whitfield answered
Is your machine slow? IE took about 5 secs on my machine at work... However, Chrome was instant and Firefox was near-instant (maybe 0.25 -> 0.5 secs). I think the issue here maybe two fold: 1. The graph seems to have a lot of data points - really, for that style of graph, I think a weekly summary would give a reasonable indication. I mean, who's going to be doing any integration analysis on it? 2. The javascript engine in IE sucks. Badly. Apparently IE9's JS engine is supposed to suck less. How much less remains to be seen, I guess.
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
My machine is not too slow. I reckon it is slowed down via an on-access virus scanner (corporate IT security policy!). I agree on the granularity. If you check Stackoverflow, they have the option of filtering too - maybe something to suggest here?
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
I must admit my experience with most browsing is much better on Chrome than IE. My fellow devs swear by FF, but I prefer Chrome.
0 Likes 0 ·
DaniSQL avatar image DaniSQL commented ·
FF and Chrome load instantly on my machine too but IE sucks on my machine. Dont know why.
0 Likes 0 ·
Cyborg avatar image Cyborg commented ·
How about having a drill down reports for karma history?
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
It does seem to take a few seconds to load stuff, but the performance isn't too bad.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.