Mohit Sharma

275 posts

Mohit Sharma banner
Mohit Sharma

Mohit Sharma

@m__sharma_

Engineer at @amazon in Morning, Love Anfield Nights ⚽ and F1 weekends. 🏎️ Ex : Software Developer && Instructor at @interview_bit @scaler_official

New Delhi, India Katılım Şubat 2019
153 Takip Edilen71 Takipçiler
Sabitlenmiş Tweet
Mohit Sharma
Mohit Sharma@m__sharma_·
“i just hope the universe puts the right person in your path. like your mom was for me. you know, someone who brings out the good stuff in you. because my god, son, what a force you will be.” #ThisIsUs
Mohit Sharma tweet media
English
1
43
276
0
Naman Bhalla
Naman Bhalla@Naman_Bhalla·
“If you wish to achieve some kind of intellectual immortality, writing for the AIs is probably your best chance.” One of the most impactful while easily accessible ways to shape AGI today is by building the training environments that future AI models will learn from. High-quality work here won’t just advance AI - it will free humans to focus on higher-order problems. Contribute to intellectual immortality, and you may just help pave the path to biological immortality as well.
English
2
0
5
470
Mohit Sharma retweetledi
Harsha Bhogle
Harsha Bhogle@bhogleharsha·
Test cricket is the greatest sport in the world
English
512
4.4K
50.7K
902.2K
Mohit Sharma
Mohit Sharma@m__sharma_·
@arpit_bhayani I think it’s the way it is taught and the motivation (interviews) that makes it less interesting. But if you start coupling every topic with its actual use cases, it actually makes you think differently.
English
0
0
2
543
Arpit Bhayani
Arpit Bhayani@arpit_bhayani·
DSA is the least interesting subject from the entire CS curriculum.
English
137
56
1.8K
307.1K
Mohit Sharma
Mohit Sharma@m__sharma_·
@SumitM_X Second one is called implicit join. The results will be exactly same. If I don’t consider execution plan and think logically, the difference is first will be using the condition while joining but the second first execute cross join and then apply where condition.
English
1
0
10
1.3K
SumitM
SumitM@SumitM_X·
What’s the difference between these 2👇 SELECT * FROM A JOIN B ON A.id = B.id; vs SELECT * FROM A, B WHERE A.id = B.id;
English
13
6
91
12.7K
Arpit Bhayani
Arpit Bhayani@arpit_bhayani·
do one deep research a day. - on any topic you like - on any LLM you prefer I have been digging deeper into Go and databases (ofc), Philosophy and History. Literally anything and everything you wanted to know is available at your fingertips. Use it.
English
38
55
1.3K
39.4K
Mohit Sharma
Mohit Sharma@m__sharma_·
If this made you look at ORDER BY differently, retweet the first post. Follow for more deep dives into systems internals, databases, and performance tricks from real-world production. Got questions? Drop them below 👇 #MySQL #Databases #SQL #SystemDesign #Performance
English
0
0
0
82
Mohit Sharma
Mohit Sharma@m__sharma_·
7. Why should you care? Because every time you write ORDER BY, you’re triggering all this. Understanding filesort helps you write faster queries, design better indexes, and avoid disk IO surprises in production.
English
1
0
0
86
Mohit Sharma
Mohit Sharma@m__sharma_·
I was digging through MySQL internals the other night and hit a curious thing: Using filesort. I’ve seen it in query plans for years — never gave it much thought. So I pulled the source. Turns out it’s not one algorithm, but a smart orchestration of many.👇🧵
English
1
1
2
292
Mohit Sharma retweetledi
Om Mishra
Om Mishra@theonemishra·
I promise reading this won't waste your time, but your feedback can make our day! First things are always special, no matter how small or big they are. I, along with @thetallInnov8r , have just finished building our first full-stack project-or an early stage product.
English
2
5
11
3.5K
Nancy
Nancy@_Nancy03_·
@zerodha doesn't share the auction data which seems unfair. I had short sold stock which had hit uppeer circuit. I waited for t+2 days, they sent a note that showed me how much amount I owe to zerodha.
English
1
0
1
123
Nancy
Nancy@_Nancy03_·
Now the stock hs been auctioned, I hv gone through my losses. Bt where is the data. Hw cud I find out the price at which the stock was auctioned. Sprt told that they dnt hv such info. This is something you need to b clear abt @zerodha @nikhilkamathcio
English
1
0
0
96
Mohit Sharma retweetledi
Sharie
Sharie@shariexyz·
i used to look down on people who are tied up in their 9-5 job until… one of my best friends confronted me that not everyone has the same privilege as me to start a business. i was defensive, but then i realized maybe it’s true. i’m not a breadwinner, so i don’t have any major responsibilities—if anything, i only have two corgis to feed. i have a supportive family who doesn’t intervene with my aspirations. i graduated with latin honors and have built valuable skillsets, so even if i fail, it’s easy for me to go back to corporate. i’m debt-free, so i’m not anxious about mortgages or loans. i have years of runway, so ghost months do not bother me. i’m privileged enough to fail, and that’s something not everyone can afford. each of us has different interests and preferences, influenced by our situations and circumstances. be compassionate. that’s the least you can do for others who are striving and struggling.
English
60
74
989
164.6K
BCCI
BCCI@BCCI·
BCCI tweet mediaBCCI tweet mediaBCCI tweet mediaBCCI tweet media
ZXX
51
207
3.7K
218K