Speed and ASP
Published 3.28.2005 by ~mattg
Working with ASP (not .NET, plain old ASP) teachs much about optimization. We had a page that calculated students grades for each assignment in a course, it took about 22 seconds to load.
I stared at the code for about 2 hours trying to decipher what had been written, and how to speed it up. I finally figured out that querying the same view (a very work intensive view) three times to retrieve data is pertty much pointless and the cause of the headache. I re-organized the page with very little coding and reduced the execution time to about 7 seconds.
Not bad for about a day’s work. It’s just funny how stuff gets programmed once, and then new features are just loaded on top like so much trash, until the execution suffers. Had it been a windows app, it would have taken much longer to notice the chance for optimization, since the local machine resources are much faster than an Internet connection.
I’ve been here at Commersel for almost a month and a half now, and it is going pretty well. The challenges are there to make me learn new things, but not so bad that I’m pulling my hair out. It’s nice to work on the web, it’s translates into valuable information for any consulting I do on the side.
Filed under Web Development
