Make 43 Things Faster

Man I love doing Webkinz but it loads too slow. Luckliy with this in my hands I’m sure to get this done

I just started please remind me

I’m doing a bunch of refactoring. Today I’m turning a lot of code that looks like this:

if thing.nil? || thing.empty?

into this:

if thing.blank?

We’re not quite done with the new database load balancing setup, but one side effect of what we’re working on is that pages are about 25-50% faster for logged in users. You can check out Ivan’s diagram of the setup on the blog:

http://blog.robotcoop.com/2008/02/27/load-balancing-act/

For a 4 day class focusing on performance tuning. We’ve already found 2 things that we can try…

We’re taking a 3 day class about “MySQL High Availability”. The first day was mostly stuff we already know about replication, but we should start covering clustering which should be interesting.

It took a little bit, but with Ivan’s help, things seem pretty fast and stable now.

Sweetness!

other than talking with Ivan, Laurel, Josh, Todd & Buster. The sites seems pretty zippy now so I’m marking this off my list.

In addition:
- we added an extra RAM to our master and slave DBs bringing it to 16G each
- added extra indexes to couple of tables
- added 8G of memory to memcache
- de-normalized some of our tables
- added more front end caching
The fight continues on.

I just removed one hundred and twelve million rows from our database. I feel dirty.