Saby_ExplainforSaby Explain Blogsabyexplain.hashnode.dev·10 hours agoRemedy for Poor-Performing SQL QueriesIn previous posts, we introduced you to Saby Explain, a public service for the analysis and visualization of PostgreSQL query plans. Several months after the launch we've reached the milestone of 6,000 usages, but one of the helpful features sometime...DiscussPostgreSQL
Saby_ExplainforSaby Explain Blogsabyexplain.hashnode.dev·Oct 24, 2024Best Practices for Bulk Optimization of Queries in PostgreSQLAfter reading this article, you’ll learn about the techniques we use to analyze SQL query performance when dealing with millions of queries per day and monitoring hundreds of PostgreSQL servers. We’ll talk about Saby Explain, a tool that helps us han...DiscussPostgreSQL
Pagepropagepro.hashnode.dev·Oct 24, 20245 Lessons For Next js Performance Optimization in Large ProjectsIntroduction to Next js Performance Optimization At Pagepro, we’ve spent years developing and optimizing high-traffic Next.js websites and apps for our clients. Along the way, we’ve faced numerous challenges and learned crucial lessons about Next js ...DiscussNext.js
Ritik Singhritiksingh.hashnode.dev·Oct 23, 2024Navigating System Design Trade-Offs: Balancing Performance, Cost, and ReliabilityWhen designing large-scale systems, it’s essential to find the right balance between various factors like memory, throughput, cost, latency, consistency, and availability. These elements are interconnected, and changing one often impacts the others. ...DiscussSystem Design Simplified: A Journey to Building Scalable ApplicationsSystem Architecture
The Paritosh KumarforSPACEtheparitoshkumar.com·Oct 18, 2024Optimization Problems in AI: How AI Finds the Best Solutions Among Multiple PossibilitiesArtificial Intelligence (AI) has made remarkable strides in transforming various industries by enabling machines to perform complex tasks, from medical diagnosis to self-driving cars. One of the core challenges that AI systems face in almost every do...DiscussArtificial IntelligenceAWS
Jean-Mark Wrightjaywhy13.hashnode.dev·Oct 17, 2024Order matters - making a compound index 50x fasterIntroduction Today I’ll talk about an endpoint that initially performed under 30ms, then crept up to ~500ms after a couple months. Our investigation revealed that a query, powered by a compound index was responsible for the elevated latency. We explo...Discuss·1 like·707 readsDatabases
ayoola lekanoluremi.hashnode.dev·Oct 16, 2024Lazy Loading: A Simple Way to Improve Website Speed and SEOImagine you're at a buffet, and instead of all the food arriving at once (overwhelming your plate), dishes come one at a time, just as you're ready for them. That’s exactly how lazy loading works for web content—serving resources only when needed. I...Discuss·29 readslazy loading
Shrinivas VishnupurikarforData Engineering w/ ShrinivasV73data-engineering-with-shrinivasv73.hashnode.dev·Oct 14, 2024Almost Everything You Need to Know about SQL IndexesIntroduction You’re writing SQL that get the job done. Great! Now you’ll have to upgrade yourself like Pokémons did and you need to think of other concerns as well like Integrity, Consistency, Security and Modelling and several other. Still the one t...DiscussDatabases
Deeksha Singhdeekshaaah.hashnode.dev·Oct 13, 2024How To Optimize Your LinkedIn As A StudentHey! I am Deeksha Singh, a freshman, pursuing a Bachelor of Technology in Information Technology from Guru Gobind Singh Indraprastha University. I have been an active LinkedIn user for eight months and I have learned numerous things about it and its ...Discuss·10 likesLinkedIn
Milan Jovanovićmilanjovanovic.hashnode.dev·Oct 12, 2024Scaling the Outbox Pattern (2B+ messages per day)In last week's newsletter, I talked about implementing the Outbox pattern. It's a crucial tool for reliable distributed messaging. But implementing it is just the first step. The real challenge? Scaling it to handle massive message volumes. Today, we...DiscussTransactional outbox pattern