Solve N+1 Problem in GraphQl API

Transcript

1. Solve N+1 Problem in GraphQL API Disyam Adityana Putra Team Leader @ Hash Rekayasa Teknologi
2. Ask The Audience • Raise Your Hand • Know GraphQL • Try GraphQL • Use GraphQL
3. N+1 Problem
4. dataloader to the rescue
5. dataloader • batching • caching • per request • fetch data modification
6. dataloader const DataLoader = require('dataloader') const userLoader = new DataLoader(keys => myBatchGetUsers(keys));
7. dataloader input = [2, 1, 5, 3, 4]; output = [ { id: 2, name: "two" }, { id: 1, name: "one" }, { id: 5, name: "five" } { id: 3, name: "three" } { id: 4, name: "four" } ];
8. batching • The Array of values must be the same length as the Array of keys • Each index in the Array of values must correspond to the same index in the Array of keys
9. caching const userLoader = new DataLoader(...) const result1 = await userLoader.load(1) const result2 = await userLoader.load(1) assert(result1 === result2)
10. Other implementations PHP: DataLoaderPHP Ruby: Dataloader, BatchLoader ReasonML: bs-dataloader Java: java-dataloader Elixir: dataloader Golang: Dataloader
11. Question?
12. Thank You code: https://github.com/disyam/graphql-loader