You know those crazy SQL queries. I recently optimized one of them for the project Algorea.
A service of the API was very slow and I’ve been asked if I can fix it.
I’ll describe here the process I took to do that. Along with the mindset I use when I’m facing such challenges.
I believe that the mindset is the most important part. It’s the secret that makes you better and motivated on the long run.