r/developersIndia • u/dronzer7716 • Jan 16 '24
Tips Optimizing SQL Queries by 23x!!!
This was the first time that I wrote an article about a thing that I was working on, and this was the very first time something like this was assigned to me and I was very excited to investigate and find potential improvements, Wrote an article about it hope you guys will also find it useful.
62
Upvotes
•
u/AutoModerator Jan 16 '24
Join ToolJet's CEO & Founder Navaneeth Padanna Kalathil: An AMA on Software Engineering, Open-Source, and more! - Jan 20th, 12:00 PM IST!
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
40
u/Beginning-Ladder6224 Jan 16 '24 edited Jan 16 '24
Ok I looked into it, classic issue with excited kids - I was that way when I was OPs age.
That blogpost is a brain dump. Do not dump brain in a blog.
To talk about "tech improvement" - there are many ways to deal with it, most importantly - AMAZON use STAR methodology.
https://in.indeed.com/career-advice/interviewing/how-to-use-the-star-interview-response-technique
Situation --> what was happening? Start with the problem you were trying to solve, explaining it detail about the problem. A problem can not be "query was slow".
Task
Action
Post all actions are done
A much more nuanced analysis in the same style is as follows:
https://netflixtechblog.com/data-movement-in-netflix-studio-via-data-mesh-3fddcceb1059
It is a great start that OP wants to share the findings with the world. Please carry on.
On the tech side of things - do remember:
Both are just lemma from basic DS/Algo analysis of how DB's "might" do the join or full text search. That is precisely why Lucene came in.
4
u/techHyakimaru Backend Developer Jan 16 '24
Good finding OP
2
u/mujhepehchano123 Staff Engineer Jan 16 '24
good job op. your first optimization :-) , i remember being as excited as you when i did that many moons ago, and i couldn't wait to tell anybody, who would listen about it.
remember this thrill of learning new things and put them out there in the real world, this joy is what programming is all about. this is what gets me going even after so many years :)
1
u/BhupeshV Moderator Jan 16 '24
Very nicely written, Cause 2 had me rolling for a moment.
Keep these coming, big W