Menene matsalar N+1 a cikin GraphQL kuma yaya DataLoader ke gyara ta?

Question

IT Interview Practice · Accepted Answer

**Matsalar N+1** tana faruwa lokacin da resolver na fili ke gudana sau ɗaya kowane parent kuma kowanne gudu yana aika tambayar database ɗinsa. Ɗauko jeri na posts N sannan mawallafin kowane post yana harba **tambaya 1 don posts + tambayoyi N don mawallafan** — zagayowa N+1 da ke murƙushe aiki a ƙarƙashin nauyi.

## Dalilin da ya sa yake faruwa

Resolvers suna gudana kowane fili, kowane abu. `Post.author` yana aiwatarwa daban ga kowane post a cikin jerin, kuma babu ɗayansu da ya san game da sauran, don haka kowanne yana yin `findById` nasa.

```js
// BAD: one DB call per post -> N+1
const resolvers = {
  Post: {
    author: (post, _a, ctx) => ctx.db.users.findById(post.authorId),
  },
};
```

## DataLoader: batch + cache

**DataLoader** yana jinkirta kiran `.load(id)` ɗaya-ɗaya da aka yi a cikin tick guda, sannan ya ba da maɓallan da aka tara ga wata **batch function** guda da ke ɗauko su duka a cikin tambaya guda. Yana kuma yin **cache** ta maɓalli a cikin buƙatar, don haka ids da aka maimaita kyauta ne.

```js
import DataLoader from "dataloader";

// create ONE loader per request (put it on context so caching is request-scoped)
const userLoader = new DataLoader(async (ids) => {
  // ids arrives as [1, 2, 3, ...] -> a single batched query
  const users = await db.users.findByIds(ids);
  // MUST return values in the SAME ORDER as ids
  return ids.map((id) => users.find((u) => u.id === id));
});

const resolvers = {
  Post: {
    author: (post, _a, ctx) => ctx.userLoader.load(post.authorId), // batched
  },
};
// Now N author resolvers collapse into 1 query: total 2 queries, not N+1.
```

Ƙa'idodi biyu: ƙirƙiri loaders **kowace buƙata** (ba a matakin duniya ba — za ka zubar da tsofaffin bayanai tsakanin masu amfani), kuma dole batch function ta mayar da sakamako **a ainihin tsarin maɓallan**.

## Me ya sa yake da muhimmanci

N+1 ita ce tarkon aikin GraphQL da aka fi sani kuma tambaya ce da kusan tabbas za a yi a hira. Nuna cewa kana kai ga DataLoader — kuma ka san *dalilin* da ya sa dole ya zama request-scoped kuma mai kiyaye tsari — yana nuna ƙwarewar samarwa ta gaske.

Dalilin da ya sa yake faruwa

DataLoader: batch + cache

Me ya sa yake da muhimmanci

Tambayoyi masu alaƙa