Weekly Status Update: Nov 14-20
Last week, I spent most of my time working with Dean on a redesign of the channel details page. We have some new features in Miro (like the ability to download invididual videos) that aren’t being used by the Guide, so we’re trying to work them in.
I spent some time working on making subscriptions faster. Previously, the subscription-hit page added a row directly into the subscription table, which was getting slow sometimes (1,201,922 subscriptions total). Now, they go into a holding table which is dumped into to main table when the popularity statistics are updated (every 5 minutes). From a quick test, it seems much much faster, and my timing statistics back that up.
Matt moved the Guide over to the new server so that Trac and Videobomb won’t interfere with it, so I did a little bit of work figuring out what that needed, and setting things up once it moved over. It certainly feels much faster.
This week I’ve been doing some more work on making the Guide faster. With the new co-branded versions being released in the near future and an API in the not-as-near future, we think that the Guide could be getting a lot more traffic and so it’ll need to be faster. Right now I’m working on putting a lot of the non-frequently-changed data into memcached.
I’m taking today-Friday off, but then I’ll be finishing up the caching stuff and moving back to the details page redesign.