4 ms·
I did a take-home exercise earlier this week. They provided access to a database and said << do thing >>. Implied was that I should << do thing >> with a progra
by jacques_chester 6y ago
I did a take-home exercise earlier this week. They provided access to a database and said << do thing >>. Implied was that I should << do thing >> with a program rather than a query.
One of my solutions used Golang. It pulled data, looped a lot, then put results back. It took approximately 4 minutes.
I included a second solution, using SQL. It selected into the results table with a little bit of CTE magic. It took approximately 600ms.
- bartread 6y agoInteresting, and I've seen and implemented similar optimisations plenty of times. The right query in the right place at the right time can make all the difference. Did you hear back from them with a positive response?
- jacques_chester 6y agoNot yet, but it's a small firm. I trust the people involved and I don't mind giving them some time to go over it.
- bartread 6y agoWell, best of luck: I hope you get the job.