Category
Categories
Sort By
Tag Archives: QueryOptimization

Java/JVM

Hibernate N+1 Query Problem: Causes, Solutions and Production Best Practices

Introduction A production incident often starts with something that looks harmless. A developer ships a Spring Boot API to “Return all customers with their orders.” The code is simple, the response looks correct and everything works perfectly in development. Then traffic grows and the same endpoint causes: Database CPU spikes Connection pool exhaustion Higher API […]

Rajdeep Dabral
Rajdeep Dabral
Read

Data Engineering

Spark SQL Query Optimization Techniques for Data Engineers

SQL (structured query language) is the building block of data engineering, it plays a significant role in managing, manipulating, organizing, and retrieving data in relational databases. In data engineering, huge volumes of data with increasing complexity are processed on a daily basis, and to manage it, data engineers work on distributed systems like Spark. On […]

Shristy Shreya
Shristy Shreya
Read
Archive