The query that ate the database
For a year, route search in Cuando was one recursive SQL query. This autumn the app started calling it, and it started running out of memory. How route search in SQL works, why it blows up, and why, as of today, it runs in the Worker instead.
Read more