RunningAHEAD - Topic: fixed site performance issue

fixed site performance issue (Read 782 times)

eric :)

posted: 9/13/2008 at 7:43 AM
modified: 9/13/2008 at 7:46 AM

Hi everyone,
If you have many entries in your training log, I'm sure you noticed that it takes a long while to load the summary page. I'm sure you also noticed that once in a while, it takes forever to load any page on RA. It turned out that both of these problems are related. In the case of the summary page, lots of computation is needed to generate weekly, monthly, and yearly numbers.

The second problem is less obvious. It is caused by the pace bunny pages in the mileage groups. To generate the pace chart, the server had to do lots of searching and adding. And if multiple users are viewing the pace charts, the server grinds to a halt and you are affected even though you may not even belong to a mileage group.

I started work on the summary page for the new log this week. One of the goals was to make it load faster by not having to do unneeded calculations. For example, there is no need to calculate your mileage from previous years since that hardly ever changes if it's changed at all. This change was simple and surprisingly effective. As an added bonus, it made the YTD charts in the mileage groups load very fast.

I decided to add this fix now instead of waiting for the new log to complete because of the performance improvement to the server. Hopefully, we will no longer experience long lags. You can also click away at the pace charts without having to wait a long time for them to load anymore.

Also, I added a bit of code to remove users that reached their yearly mileage goal from the pace charts so that other users can have a chance to be on the first page. These users will no longer need to leave the groups. It's up to the administrators of these groups to decide how to acknowledge their achievements.

eric :)

mikeymike view log	posted: 9/13/2008 at 2:18 PM
	Nice work as always, Eric. And thanks for updating us at quarter to four this morning!!! What kind of techno beats were you rocking during last nights all-night coding marathon?

dgb2n view log Dave	posted: 9/13/2008 at 2:35 PM
	Awesome job, Eric. The site is noticeably faster. I knew something happened when I loaded up my pace group this AM.
	I ran a mile and I liked it, liked it, liked it. dgb2n@yahoo.com

eric :)

posted: 9/13/2008 at 2:41 PM

I was on some kind of high last night. It's as all the planets aligned or something after I got out of work. Even the miles on the treadmill flew by which they never did. Besides, this fix required some server down time and I didn't want to affect too many users. The night owls in Alaska (you know who you are) and the folks in Europe and Asia took the hit for a while though but it's worth it if it means the frequency of slow server response is reduced greatly.

Wingz	posted: 9/13/2008 at 2:43 PM
	Thanks for your hard work. Again. The only reason that RA is such a great site is that YOU do such great work. But 3AM? That's insane, man!

zoom-zoom view log Registered for #2	posted: 9/13/2008 at 4:01 PM
	<3
	Kirsten '07: 1324.5 mi '08: 1561 mi ... • Ladies Locker Room • .: 2009 Goals :. • Run 1750 miles • 2 marathons (May - Bayshore, Fall - ?) • PRs: 5k ~ 15k ~ 25k? ~ HM ~ 26.2 • 1st trail relay (North Country)

johnny franglais	posted: 9/13/2008 at 4:24 PM
	Bien fait Eric.
	A challenge in which a successful outcome is assured is not a challenge. -Christopher McCandless-

Run To Win view log Blaine Moore	posted: 9/13/2008 at 5:45 PM
	Thanks again, Eric!
	Run to Win I just started using Twitter - anybody else on there? http://twitter.com/RunToWin

backstretch view log	posted: 9/13/2008 at 6:56 PM
	Thanks Eric, great work!!

Daddyo view log It's BQ year!	posted: 9/14/2008 at 7:51 PM
	many thanks and appreciations from the great white north!
	Dave ~ Marathon Maniac #1166 www.daddyo.ca Success is sweet and sweeter if long delayed and gotten through many struggles and defeats.

jeremys view log	posted: 9/15/2008 at 1:08 PM
	Thanks Eric. I noticed a BIG improvement in the 1000-mile club load time!
	Jeremy