My Blogs 📝

blog image
Optimizing SQL Queries by 23x!!!
32K+
30+
300+

Our submissions table which has more than 700k records was performing horribly. The maximum time to just fetch the data from the table was more than 6 seconds. The query was rather simple. All we had in there were 4 joins, a couple of where clauses (about 4), sorting read more by clicking on the title..

Written on: 15th Jan 2024
Made with 🔥 by Navneet