GraphQLのN+1問題を解決したい

Slide 1

Slide 1 text

(SBQI2-ͷ/໰୊Λ ղܾ͍ͨ͠ ʙ/PEF+4ͷΠϕϯτϧʔϓʹ͍ͭͯʙ ͔ΖͯΜ

Slide 2

Slide 2 text

ܦҢ

Slide 3

Slide 3 text

(SBQI2-ͷಛ௃ w ΫΤϦܕݴޠɻΫΤϦܕݴޠʹ͸ҎԼͷछྨ͕͋Δ w RVFSZ w NVUBUJPO w TVCTDSJQUJPO

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

(SBQI2-ͷಛ௃ w 42-Λൃߦ͢Δͱ͖ϊʔυ͝ͱʹൃߦ͢ΔͷͰɺ/໰୊͕͓͖΍͍͢ w ࠓ೔͸͜ΕΛղܾ͍͖͍ͯͨ͠

Slide 6

Slide 6 text

ํ਑

Slide 7

Slide 7 text

ํ਑ w &BHFSMPBE w ઌʹ42-Λൃߦ w -B[ZMPBE w ͋ͱͰ·ͱΊͯ42-Λൃߦ w CBUDIJOHͱݺ͹ΕΔ w (SBQI2-ͷ৔߹͸͕͍ͬͪ͋ͬͯ͜Δ

Slide 8

Slide 8 text

No content

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

ํ਑ w -B[ZMPBEΛ࣮ݱ͢Δखஈͱͯ͠ʮ%BUB-PBEFSʯͱ͍͏ϥΠϒϥϦ͕͋ Δʢ'BDFCPPL੡ʣ

Slide 11

Slide 11 text

MPBE MPBE MPBE QFSGPSN

Slide 12

Slide 12 text

ํ਑ w ͔ͤͬ͘ͳͷͰɺࢼ͠ʹॻ͍ͯΈΔ͜ͱʹͨ͠

Slide 13

Slide 13 text

࣮૷

Slide 14

Slide 14 text

࣮૷ w CBUDIJOHʹඞཁͳΩʔΛཷΊࠐΉʢࠓճͷ৔߹͸BEWJEʣ w Ωʔ͕͢΂ͯू·ͬͨΒɺCBUDIGVODΛ࣮ߦ͢Δ

Slide 15

Slide 15 text

࣮૷

Slide 16

Slide 16 text

࣮૷

Slide 17

Slide 17 text

࣮૷

Slide 18

Slide 18 text

࣮૷

Slide 19

Slide 19 text

w ΍͔ͬͨʂʁ

Slide 20

Slide 20 text

΍ͬͯͳ͍

Slide 21

Slide 21 text

΍ͬͯͳ͍

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

MPBE MPBE MPBE

Slide 24

Slide 24 text

w CBUDI࣮ߦλΠϛϯάΛ੍ޚ͠ͳ͍ͱ͍͚ͳ͍ w CBUDI͸શͯͷMPBE͕૸ͬͨޙͰಈ͍ͯ΄͍͠ w MPBEͷ࣮ߦ͕ऴΘͬͨޙɺCBUDIͷ࣮ߦΛॻ͚͹͍͍ͷͰ͸ʁ  ʢಉظతʹॻ͘ʣ w ͢΂ͯͷMPBE͕͍ͭऴΘΔͷ͔͕ɺ(SBQI2-ͩͱΘ͔Βͳ͍

Slide 25

Slide 25 text

w %BUB-PBEFSʢϥΠϒϥϦʣΛ࢖͏ͱ͖͸ಉظతʹॻ͔ͳͯ͘ྑ͍Α͏ͩ w ͦ΋ͦ΋CBUDIͷ࣮ߦॲཧΛॻ͔ͳͯ͘Α͍ w ෆࢥٞ w Ͳ͏ͨ͠Β͍͍Μͩʁ%BUB-PBEFSͲ͏͍ͯ͠ΔΜͩʁ w ΑΜͰΈͨ w ࣮ݱํ๏͕Θ͔ͬͨ

Slide 26

Slide 26 text

౴͑

Slide 27

Slide 27 text

౴͑

Slide 28

Slide 28 text

౴͑

Slide 29

Slide 29 text

౴͑

Slide 30

Slide 30 text

౴͑

Slide 31

Slide 31 text

ߟ࡯

Slide 32

Slide 32 text

w /PEF+4ͷΠϕϯτϧʔϓΛཧղ͢ΔͱΘ͔Γ΍͍͢

Slide 33

Slide 33 text

ྫʣͲ͏͍͏ॱ൪Ͱ࣮ߦ͞ΕΔʁ

Slide 34

Slide 34 text

ͨ͑͜

Slide 35

Slide 35 text

w +BWB4DSJQU͸͸͡Ίʹ͢΂ͯಉظతʹ࣮ߦ͞ΕΔ w ͦͷ͋ͱ͸Πϕϯτϧʔϓ͕ճΔ͚ͩ w ͜Ε͸/PEF+4΋ϒϥ΢β΋ಉ͡ w ࠓճ͸/PEFͷ࿩

Slide 36

Slide 36 text

No content

Slide 37

Slide 37 text

No content

Slide 38

Slide 38 text

w IB ϧʔϓ͕ճΔલʹɺಉظॲཧ͕ߦΘΕΔ ಉظॲཧϑΣʔζ

Slide 39

Slide 39 text

w IB ಉظॲཧϑΣʔζ

Slide 40

Slide 40 text

w IB ಉظॲཧϑΣʔζ

Slide 41

Slide 41 text

w IB ಉظॲཧϑΣʔζ

Slide 42

Slide 42 text

w IB ಉظॲཧϑΣʔζ

Slide 43

Slide 43 text

w ͬͬE ී௨ʹ࣮ߦ͞Εɺͱग़ྗ ಉظॲཧϑΣʔζ

Slide 44

Slide 44 text

a w ͬͬE ϧʔϓલ

Slide 45

Slide 45 text

a w ͬͬE ϧʔϓલ

Slide 46

Slide 46 text

a w ͬͬE Πϕϯτϧʔϓ

Slide 47

Slide 47 text

a w ͬͬE Πϕϯτϧʔϓ

Slide 48

Slide 48 text

No content

Slide 49

Slide 49 text

w ͬͬE Πϕϯτϧʔϓ ඞͣಉظ࣮ߦ͞Εͨޙʹ࣮ߦ͞ΕΔ

Slide 50

Slide 50 text

·ͱΊ w (SBQI2-ͷ/໰୊ղܾ͸MB[ZMPBEͷ૬ੑ͕͍͍ w MB[ZMPBEΛ͢Δࡍ͸ɺ͢΂ͯͷLFZ͕MPBE͞ΕͨޙʹCBUDIΛ࣮ߦ͢Δඞཁ͕͋ Δ w QSPDFTTOFYU5JDLͳͲΛ༻͍ͯɺ  ಉظ࣮ߦ͕ߦΘΕͨޙʹCBUDIJOH͕࣮ߦ͞ΕΔ͜ͱ͕  อূ͞Ε͍ͯΔඞཁ͕͋Δ w /PEF+4ͷΠϕϯτϧʔϓΛཧղ͢ΔͱΘ͔Γ΍͍͢ w DBDIFJOHͳͲͷศརػೳΛඋ͑ͨOQNϞδϡʔϧΛ࢖͏ͱָͩΑ