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.
Namun di balik layar ORM akan menjalankan SQL seperti berikut.
SELECT * FROM users;Kemudian:
SELECT * FROM posts WHERE user_id = 1;SELECT * FROM posts WHERE user_id = 2;SELECT * FROM posts WHERE user_id = 3;Jika terdapat 500 user maka akan terjadi:
- 1 query mengambil user
- 500 query mengambil posts
Total menjadi 501 query.
Mengapa Disebut N+1?
Huruf N melambangkan jumlah data yang diperoleh dari query pertama.
Misalnya:
Share:
More in Technology
View categoryFrom RWA Tokenization to On-Chain Payments: Build Scalable Web3 Ecosystems with Utility Token Development
Build scalable Web3 ecosystems with RWA tokenization, utility token development, and on-chain payments. Get 30% OFF eligible utility token development services this Halloween.
READ ARTICLEMetadata 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 ARTICLE