Welcome GuestLogin

A Drunken Wiki


A Drunken Wiki is the companion wiki to the blog "A Drunken Madman", written by Jason Brown.


Search the wiki

Vaccination Saves Lives: Stop The Australian Vaccination Network

Find me on Twitter, Facebook, Google+, Pinterest and LinkedIn

Pin It

Alpha Archive Atheism Blue Mountains Climbing Cycling Development DotNet GPS Guitar HMHB JavaScript JQuery LINQ Meta MTB Music Perl Powershell RNP SharePoint Skepticism Social Media Training Ukulele Vaccines Visual Studio WebParts Woodford Festival 2011 XML



Modified on 2011/12/23 16:11 by Administrator Categorized as Uncategorized
Here are some troubleshooting notes for Skepticator's performance issues

OK, so here's the problem

Skepticator's Homepage is subject to a severe slow-load issue, and has been for some time. It's therefore prone to timeouts and frustrating to use.

Slow pages: /default.aspx and /search.aspx

Fast pages: /YouTube.aspx

So given that there ARE fast pages, it's not a whole-server or whole-website issue.

Caching the data call to pull the feed items results in a saving of about 300ms or so. Which is good, but doesn't help us much.

Adding instrumentation to the page reveals that between the PreInit() and Unload() events of the ASP.NET lifecycle is a period of about a second or so

The twitter feeds load in ~200ms

So the problem MJST be outside the ASP.NET lifecycle. So it's not my code, right?

Well, maybe.

Problem solved: There are 1.8 million rows in the search history table. This was being accessed with a nested query (in order to strip duplicates), and was taking upwards of 15s to process. But because it's in a User Control called UsefulStuff.ascx it didn't get benchmarked in with the rest of the page events. Intrumenting the Use Control code eventually showed it up. Skepticator home and search are now loading in < 1s each (though SEO might take a hit from the search namespace being less open to googlebot)


ScrewTurn Wiki version Some of the icons created by FamFamFam.