Did You Know: Solving the N+1 Problem with a DataLoader Pattern (MVP Series feat. Sachin Namjoshi)

What if one query turned into 39? That’s the dreaded N+1 problem—and it can kill performance.

In this episode of the Did You Know MVP Series, ServiceNow MVP Sachin Namjoshi shares how to solve it with a DataLoader pattern in script includes. Instead of hammering the database with dozens of calls, Sachin shows how batching queries collapses 39 lookups into just one.

We’ve also covered other ways to squash the N+1 problem in previous videos using RLQUERY and addJoinQuery(). Sachin’s tip adds another powerful tool to your developer toolkit.

👉 Dive deeper with Sachin’s full blog post here: https://www.servicenow.com/community/...

📌 Chapters:
0:00 Intro – The N+1 Problem
0:19 Previous solutions: RLQUERY & addJoinQuery
0:42 Introducing the DataLoader Pattern
0:57 Demo: Script Include Implementation
3:30 Demo Results – 39 Queries vs 1 Query
4:09 Recap & Blog Callout
4:38 Closing