Forum Optimizations

**aperson** · 01-3-2011, 03:12 AM

I made some optimizations to the VBulletin code that handles how the forums are displayed. Everything should be loading a fair bit more quickly now. Let me know if you run into any issues on the forums.

who_cares973 · 01-3-2011, 04:22 AM

more like lightning fast

**nois-or-e** · 01-3-2011, 05:33 AM

**Coolboyrulez0** · 01-3-2011, 05:34 AM

ap is the man 8)

ghost- · 01-3-2011, 08:00 AM

I have a little more respect for you now aperson. Not that my respect should have any impact on you whatsoever, I just wanted to let you know.

**TC_Halogen** · 01-3-2011, 10:17 AM

They're definitely faster on my end. What exactly did you do?

**One Winged Angel** · 01-3-2011, 11:43 AM

mad fast for me, and that's with my terrible mcmaster internet connection right now

you're the man, ap

**kmay** · 01-3-2011, 11:45 AM

yea posting is a **** ton faster

**TC_Halogen** · 01-3-2011, 11:46 AM

I agree - the most noticeable improvement is the time it takes for a post to appear on the page; you don't have to wait 5+ seconds for the post to show up in the thread, it shows up immediately.

**aperson** · 01-3-2011, 01:02 PM

Quote:

Originally Posted by TC_Halogen

They're definitely faster on my end. What exactly did you do?

A lot of the queries that retrieve the latest updated posts, like the queries to display the last post on each forum in the index, were running really slowly because MySQL's query optimizer was fudging around and choosing the wrong index a lot of the time. I set all of those queries to be forced to use the right index and it turned all of these queries that have about a 0.5s average time to a 0.005s average time.

cedolad · 01-3-2011, 02:11 PM

I don't think I noticed it until I read this.

**cry4eternity** · 01-3-2011, 03:08 PM

Click on person's name --> FFR profile

No more stupid forum profiles as the first option

. Who uses those anyway?

**customstuff** · 01-3-2011, 03:11 PM

Testing...

Edit: The difference for me is quite minor, but I can tell that it has improved. Nice job AP

**aperson** · 01-3-2011, 03:19 PM

Quote:

Originally Posted by cry4eternity

Click on person's name --> FFR profile

No more stupid forum profiles as the first option

. Who uses those anyway?

It's on my list to rip those out of vbulletin.

**aperson** · 01-3-2011, 03:39 PM

It looks like a lot of the slowness now is caused by profile queries.

Off to tidy up profiles~~~

Xx{Midnight}xX · 01-3-2011, 07:10 PM

Sexy.

**Zageron** · 01-3-2011, 11:38 PM

Very nice ap. I noticed it!

01-3-2011, 03:12 AM	#1
aperson FFR Hall of Fame Join Date: Jul 2003 Location: Houston Posts: 3,428	Forum Optimizations I made some optimizations to the VBulletin code that handles how the forums are displayed. Everything should be loading a fair bit more quickly now. Let me know if you run into any issues on the forums. __________________

01-3-2011, 04:22 AM	#2
who_cares973 FFR Player Join Date: Aug 2006 Location: :U Age: 35 Posts: 15,407	Re: Forum Optimizations more like lightning fast __________________

01-3-2011, 05:33 AM	#3
nois-or-e SponCon Aficionado Join Date: Mar 2007 Location: doot~ Age: 38 Posts: 3,250	Re: Forum Optimizations o/ __________________

01-3-2011, 05:34 AM	#4
Coolboyrulez0 VICES Join Date: Aug 2006 Location: Germany Age: 30 Posts: 10,031	Re: Forum Optimizations ap is the man 8)

01-3-2011, 08:00 AM	#5
ghost- Banned Join Date: Dec 2010 Location: Nebraska Age: 30 Posts: 787	Re: Forum Optimizations I have a little more respect for you now aperson. Not that my respect should have any impact on you whatsoever, I just wanted to let you know.

01-3-2011, 10:17 AM	#6
TC_Halogen Rhythm game specialist. Join Date: Feb 2008 Location: Bel Air, Maryland Age: 32 Posts: 19,376	Re: Forum Optimizations They're definitely faster on my end. What exactly did you do?

01-3-2011, 11:45 AM	#8
kmay Don't forget me Join Date: Jan 2007 Location: USA Age: 31 Posts: 6,491	Re: Forum Optimizations yea posting is a **** ton faster __________________

01-3-2011, 11:46 AM	#9
TC_Halogen Rhythm game specialist. Join Date: Feb 2008 Location: Bel Air, Maryland Age: 32 Posts: 19,376	Re: Forum Optimizations I agree - the most noticeable improvement is the time it takes for a post to appear on the page; you don't have to wait 5+ seconds for the post to show up in the thread, it shows up immediately.

01-3-2011, 02:11 PM	#11
cedolad moonchild~ Join Date: Jan 2007 Location: . Age: 30 Posts: 6,879	Re: Forum Optimizations I don't think I noticed it until I read this.

01-3-2011, 03:08 PM	#12
cry4eternity ~ added for cuteness Join Date: Jan 2007 Location: Maryland Age: 31 Posts: 979	Re: Forum Optimizations Click on person's name --> FFR profile No more stupid forum profiles as the first option . Who uses those anyway? __________________ I'm retired

01-3-2011, 03:39 PM	#15
aperson FFR Hall of Fame Join Date: Jul 2003 Location: Houston Posts: 3,428	Re: Forum Optimizations It looks like a lot of the slowness now is caused by profile queries. Off to tidy up profiles~~~ __________________

01-3-2011, 07:10 PM	#16
Xx{Midnight}xX FFR Player Join Date: Aug 2007 Age: 31 Posts: 8,548	Re: Forum Optimizations Sexy.

01-3-2011, 11:38 PM	#17
Zageron Zageron E. Tazaterra RRR Developer & DevOps Support Join Date: Apr 2007 Location: BC Age: 32 Posts: 6,586	Re: Forum Optimizations Very nice ap. I noticed it! __________________ Help Develop FFR

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)