3 ms·
For those interested in the technical details, here are some changes we made to better-handle the traffic spike: * Remove some of the MySQL-specific query synt
by paulproteus 13y ago
For those interested in the technical details, here are some changes we made to better-handle the traffic spike:
* Remove some of the MySQL-specific query syntax to make faceted search at openhatch.org/search/ work nicely. A goal of the current implementation is that if you search for "C" you won't find "C++". We implement this by a crazy hack of MySQL REGEX queries, which are (iirc) always unindexed, which is bad news under load. We should probably switch this to client-side faceted search, as here in 2014, it's safe to assume people have Javascript.
* Stop using synchronous requests.get() to fill the cache of blog posts that . The problem here is that if the cache is empty, every web worker will try to fill it. This leads to massive queuing of inbound requests, which is always bad news.
- Use CloudFlare in front of us, so at least people get reasonable error messages, and so static resources don't bother our server.
It's still not the speediest site in the world, but it's mostly handling the traffic, from what I can tell.
I filed these as bugs:
* https://openhatch.org/bugs/issue927 https://openhatch.org/bugs/issue927
* https://openhatch.org/bugs/issue928 https://openhatch.org/bugs/issue928
If you're interested in helping out, by all means join us. We love new contributors. Over 26 people contributed to the codebase in 2013, and per http://openhatch.readthedocs.org/en/latest/getting_started/installation.html http://openhatch.readthedocs.org/en/latest/getting_started/i... we've tested the dev environment setup process on Mac, Windows, and Linux, and it should take 10 or fewer minutes.