Database Changes to Find Tagged Questions Faster: Answers and Discussion


In the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find questions with a specific tag. We threw up our hands and said it’s time to make database changes, but we had a few restrictions:

We have a lot of existing code that uses the Posts.Tags column That code does selects, inserts, and updates We want our changes to be backwards-compatible: old code still has to work We need to give developers an option for slow queries, letting them change those slow queries to get faster performance if they want it