Yep

[branchandroot]

The only thing I really have to say about AO3's latest contretemps is: I told you so~

When a platform is so fucked up that the only way to make it run is to take out the navigation, then it's time to think real hard about who's been driving development.

Comments

[momijizukamori]

I kind of want to see the load graph of before and after they disabled tags.....

[branchandroot]

*snerks* Yeah, I think that would be diagnostic all right.

This is why Tumblr doesn't actually /index/ tags under a certain threshhold or index back in time indefinitely. When you have that many trash-tags, serving as meta rather than as actual searchables, you really have to make some choices.

[momijizukamori]

Yeah, user-formable tags is deeeeefinitely sketchy space for indexing. It was something I actually considered in hypothetical for my Drupal-based cosplay site.

[dragonscrawl]

And AO3 thoughtfully provides via their status twitter!

Speaks for itself, really.

[momijizukamori]

....oh my.

[branchandroot]

O_O Oh my unholy fuck.

Is that table not even partitioned? Are they just calling the whole bloody thing for every sidebar and parsing after that? Good lord.

[synecdochic]

Momiji can attest to the fact that when I saw that, I was just sitting there muttering "oh my god. oh my god."

[branchandroot]

I think I'm /still/ going "oh my god". I mean... /damn/.

[exor674]

I have to wonder what server that box was for though. Database or an app box?