Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

The unexpected hit was just users using the full text search, right? That probably should have been one of the first things tested as I assume that would be a bottleneck in speed in all stages of development...or at least it has been in my experience.

I often try to think of ways to not have full text search...this case is a little more difficult, but why not create a list of common recipe names (i.e. "grilled cheese" would be a facet for all grilled cheese sandwiches) and store it as a static json? It would take some taxonomy work on the backend but the list as JsON could easily be less than a MB and the. You wouldn't have to worry about full search as much...full search could still be an option, just not a top of the front page option.



Agree, this was the Achilles heel. It was total blunder not testing full text.

In our defense this page was supposed to be HTTP cached and that didn’t happen which led to this domino effect.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: