lol

___________________

i actually noticed that!
now i can finally browse jem's smoking hot girls thread without any interuptions, thanks bro.

___________________
http://www.soundcloud.com/gera

quote:

Originally posted by Swamper I made the forums faster again. Yours, -Swamper

Now if you could just do that other thing we were talking about a while ago!!!!

___________________

quote:

Originally posted by chinamon chinamon is INCH MOAN. LOL so fitting.

quote:

Originally posted by VDub Now if you could just do that other thing we were talking about a while ago!!!!

Swamper doesnt swing for the other team maricon.

holy shit... its flying now! thanks

quote:

Originally posted by geroin now i can finally browse jem's smoking hot girls thread without any interuptions, thanks bro.

hahahaah

___________________
http://www.beatport.com/jonathan-rosa/

Dear Swamper,

can you explain in nerd talk what you actually did?



My other idea is to start a Dear Swamper thread where TAs can ask Swamper all types of questions and he can answer them to best of his abilities.

Like a Dear Abby column. Swamper can fix all our problems.

Swamper FTW

___________________
Join my Facebook page: www.facebook.com/LetThemHaveCake

quote:

Originally posted by StereoPrincess Dear Swamper, can you explain in nerd talk wh0at you actually did?

I tweaked some mysql settings and corrected a stupid change (on my part) from a few weeks back that had to do with how sticky events are shown. I changed them to be like events in that they automatically 'expire' after the date has passed -- what I did incorrectly was assume that mysql would cache the query that determined which threads were event stickies. So, it was checking on EVERY pageview of each sub-forum in EVERY forum. Stupid beyond words. I now dump it to it's own db table and it's a trivial operation (since it's now checking against ~10 records versus 500,000+). (summoning Diginut: alternatively I can dump it to a static file or keep that query in memory.. I know you love mysql)

quote:

Originally posted by StereoPrincess My other idea is to start a Dear Swamper thread where TAs can ask Swamper all types of questions and he can answer them to best of his abilities. Like a Dear Abby column. Swamper can fix all our problems.

lol... as much as I like this idea it will probably get me in trouble if I'm completely honest Savage Love style.

___________________

"In a world of illusion you only see what you feel"

Last edited by Swamper on May-23-2010 at 14:56

quote:

Originally posted by StereoPrincess Dear Swamper, can you explain in nerd talk what you actually did?

what was actually causing the severe lag on the forum was something about how the threads were indexed each time a user would navigate within the forum. it had to go through 500,000 threads each time and swamper found a way to make it quicker. i dunno exactly how but he did it.

___________________

quote:

Originally posted by Rodrico Swamper doesnt swing for the other team maricon.

haha i was about to say something similar.

___________________