Share:
N+1 Query Problem: Salah Satu Penyebab Aplikasi Lambat yang Sering Tidak Disadari
Pelajari apa itu N+1 Query Problem, penyebab, dampaknya terhadap performa aplikasi, serta berbagai cara mengatasinya menggunakan JavaScript, Node.js, ORM seperti Prisma, Sequelize, TypeORM, hingga teknik optimasi query database.
Total menjadi 101 query.
Semakin besar jumlah data, semakin besar pula jumlah query yang dikirim ke database.
Contoh Kasus
Misalkan kita memiliki dua tabel.
Users
id | name |
|---|---|
1 | Alice |
2 | Bob |
3 | Charlie |
Posts
id | title | user_id |
Setiap user dapat memiliki banyak post.
Kode menggunakan Prisma:
const users = await prisma.user.findMany()
for (const user of users) {
const posts = await prisma.post.findMany({
where: {
userId: user.id
}
})
console.log(posts.length)
}Sekilas kode tersebut terlihat normal.
Share:
More in Technology
View categoryMetadata Management Solutions for Enterprise Data Management
Metadata management helps organizations understand what data they possess, where it resides, how it is used, and how it relates to other data assets.
AC Technician Course in Hafizabad for Practical Skills
Learn practical AC installation, repair, maintenance, and troubleshooting skills with the AC Technician Course in Hafizabad offered by United College of Technology.
READ ARTICLEHow Graphic Design Improves Performance and Business Growth
Learn how graphic design improves brand recognition, website engagement, marketing performance, lead generation, and business growth through better visual communication.
READ ARTICLE