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 2024Hi π Iβm
I am a full-stack software engineer @BeingZero, I like to learn/experiment with new technologies and love working on new projects that challenge my skills and knowledge. And also I love to talk about tech, I mean I am a software engineer so.. that is kind off a given isn't it..
π CS @ KL University: B.Tech
π» Prev. @NEGD @BeingZero @ShortCast
πLived in Hyderabad (currently), Vijayawada, Mau, Ranchi, Patna.
π Speaks English, Hindi.
βοΈ Tech Stack - React.js, Node.js, Django, MongoDB, MySQL, PostgreSQL, AWS
π¨βπ» Languages - JavaScript, Java, C++, Python (jk python is not a real language)
My Blogs π
MP Hand Cricket π (Ongoing)
An online multiplayer hand cricket game website, If you don't know what is hand cricket I feel sorry for your childhood.
Tech Stack:- React.js & React Native, Node.js (Express), WebSockets, MYSql.
Code Compiler π¨π»βπ»
An online
code
compiler, with multi language support and also support for custom
inputs.
Tech Stack:- React.js, Node.js (Express), AWS.
Jobbers ππ»
An online job hunting site, aab koi berozgaar nai rahega (jk, if government can say all this then why can't I)
Tech Stack:- React.js, Spring Boot, PostgreSQL.
Realtors π‘
An online real-estate searching portal, paise bhale na ho tumhare pass but dekh ke khus ho sakte ho tum.
Tech Stack:- Angular, Node.js (Express), MongoDB.