管理画面とユーザー機能の調和を取り戻す！~クエリパフォーマンス改善の成功物語~ / Restore harmony between administrative and user functions!

by koki otaka

Slide 1

Slide 1 text

؅ཧը໘ͱϢʔβʔػೳͷௐ࿨ΛऔΓ໭͢ʂ dΫΤϦύϑΥʔϚϯεվળͷ੒ޭ෺ޠd

Slide 2

Slide 2 text

💯

Slide 3

Slide 3 text

Slide 4

Slide 4 text

%#ͷ$16࢖༻཰😇

Slide 5

Slide 5 text

ো֐͸ಥવ΍ͬͯ͘Δ ຊ൪؀ڥʹͯΞϓϦ޲͚ͷ"1*΍ܾࡁ༻"1*ͷ ύϑΥʔϚϯε͕Ұ࣌తʹѱԽ͢Δো֐Λ֬ೝ ௐࠪͷ݁Ռɺ؅ཧը໘͔Βൃߦ͞ΕΔΫΤϦ͕ %#ͷ$16Λѹഭ͍ͯͨ͜͠ͱ͕ݪҼ

Slide 6

Slide 6 text

ো֐͸ಥવ΍ͬͯ͘Δ ͋ͳͨͳΒͲ͏ରԠ͠·͔͢ʁ😇

Slide 7

Slide 7 text

4NBSU#BOL *OD $3& αʔόʔαΠυΤϯδχΞ େߴޫؾ ͓͓͔ͨ͜͏͖ !PI@NJOJTFSB !NJOJTFSB τϐοΫ w ࠓ೥ͷ݄͔Β4NBSU#BOL+PJO w ৽ଔҰࣾ໨͸ཧֶྍ๏࢜ɺΤϯδχΞྺ೥൒ w ਓੜॳొஃͰzۓுzʜ

Slide 8

Slide 8 text

Slide 9

Slide 9 text

ো֐͸ಥવ΍ͬͯ͘Δ

Slide 10

Slide 10 text

ো֐͸ಥવ΍ͬͯ͘Δ

Slide 11

Slide 11 text

ো֐͸ಥવ΍ͬͯ͘Δ ຊ൪؀ڥʹͯΞϓϦ޲͚ͷ"1*΍ܾࡁ༻"1*ͷ ύϑΥʔϚϯε͕Ұ࣌తʹѱԽ͢Δো֐Λ֬ೝ ௐࠪͷ݁Ռɺ؅ཧը໘͔Βൃߦ͞ΕΔΫΤϦ͕ %#ͷ$16Λѹഭ͍ͯͨ͜͠ͱ͕ݪҼ

Slide 12

Slide 12 text

ো֐͸ಥવ΍ͬͯ͘Δ ݪҼ # " 😇 😇 😇 😇 😇 ؅ཧը໘

Slide 13

Slide 13 text

ղܾํ਑

Slide 14

Slide 14 text

ʢ؅ཧը໘ʣݱঢ়ͷ"1*ͱΫΤϦͷ࣌ؒΛચ͍ग़͢ ղܾํ਑ ूܭ

Slide 15

Slide 15 text

ղܾํ਑ શͯ௚͢ͷແཧͦ͏ʜ

Slide 16

Slide 16 text

ղܾํ਑ ୹ظؒͰ΍ΒͶ͹ʜ

Slide 17

Slide 17 text

ղܾํ਑ w ϘτϧωοΫͱͳΔ"1*ʹߜΓमਖ਼ w ؅ཧը໘ಛ༗ͷεΩϟϯྔͷଟ͍ΫΤϦΛશͯ௚͖͠Εͳ͍ w ୹ظؒͰো֐Λ༧๷͢Δ w ଞλεΫͱͷ݉Ͷ߹͍

Slide 18

Slide 18 text

ղܾํ਑ w ϘτϧωοΫͱͳΔ"1*ͷվम w NBY@FYFDVUJPO@UJNFͷઃఆʢຊ೔ͷϝΠϯʣ

Slide 19

Slide 19 text

ղܾํ਑ w .Z42-ͷγεςϜม਺ͷҰͭ w 4&-&$5ͷ࣮ߦλΠϜΞ΢τΛઃఆͰ͖ΔʢϛϦඵʣ NBY@FYFDVUJPO@UJNFͱ͸

Slide 20

Slide 20 text

ղܾํ਑ ᮢ஋ʢNBY@FYFDVUJPO@UJNFʹઃఆ͢Δ஋ʣͱ मਖ਼"1*ΛܾΊΔ "1*ͷमਖ਼ ؅ཧը໘ʹͷΈNBY@FYFDVUJPO@UJNFΛઃఆ͢Δ

Slide 21

Slide 21 text

ᮢ஋ͱमਖ਼"1*ΛܾΊΔ

Slide 22

Slide 22 text

ʢ؅ཧը໘ʣݱঢ়ͷ"1*ͱΫΤϦͷ࣌ؒΛચ͍ग़͢ ᮢ஋ͱमਖ਼"1*ΛܾΊΔ ूܭ

Slide 23

Slide 23 text

ᮢ஋ͱमਖ਼"1*ΛܾΊΔ w HNP@BP[PSB@WJSUVBM@BDDPVOU TJOEFY·Ͱ͕ݱ࣮తͳमਖ਼Մ ೳͳ"1*਺ʢຊʣ w NBY@FYFDVUJPO@UJNF͸ඵ

Slide 24

Slide 24 text

NBY@FYFDVUJPO@UJNFͷઃఆ

Slide 25

Slide 25 text

3BJMTͰͷઃఆ NBY@FYFDVUJPO@UJNFͷઃఆ DPSFBQJ

Slide 26

Slide 26 text

3BJMTͰͷઃఆ NBY@FYFDVUJPO@UJNFͷઃఆ ؅ཧը໘ͷΫΤϦͷΈద༻͍ͨ͠

Slide 27

Slide 27 text

NBY@FYFDVUJPO@UJNFͷઃఆ # " ؅ཧը໘͚ͩʹઃఆ͍ͨ͠

Slide 28

Slide 28 text

3BJMTͰͷઃఆ NBY@FYFDVUJPO@UJNFͷઃఆ DPSFBQJ

Slide 29

Slide 29 text

NBY@FYFDVUJPO@UJNFͷઃఆ w ·͹Βʹઃఆ͞Ε͍ͯΔ w Ϣʔβʔ޲͚ΞϓϦʹ΋ NBY@FYFDVUJPO@UJNF͕ ઃఆ͞Ε͍ͯΔ ݕূ؀ڥͰͷಈ࡞֬ೝ 👍 # " 👍 👎

Slide 30

Slide 30 text

NBY@FYFDVUJPO@UJNFͷઃఆ ͳΜͰ🥺

Slide 31

Slide 31 text

NBY@FYFDVUJPO@UJNFͷઃఆ 3%41SPYZͷઃఆݟ௚͠

Slide 32

Slide 32 text

NBY@FYFDVUJPO@UJNFͷઃఆ 3%41SPYZͷઃఆݟ௚͠ # " ઃఆ༗ ίωΫγϣϯϓʔϧ ઃఆແ ઃఆ༗ #FGPSF ؅ཧը໘

Slide 33

Slide 33 text

NBY@FYFDVUJPO@UJNFͷઃఆ 3%41SPYZͷઃఆݟ௚͠ # " ίωΫγϣϯϓʔϧ ઃఆແ ઃఆແ ઃఆແ "GUFS ؅ཧը໘

Slide 34

Slide 34 text

NBY@FYFDVUJPO@UJNFͷઃఆ w ظ଴௨Γ؅ཧը໘ͷΈʹ ઃఆ͞ΕΔ ݕূ؀ڥͰͷಈ࡞֬ೝ 👍 # " 👍 👍

Slide 35

Slide 35 text

NBY@FYFDVUJPO@UJNFͷઃఆ ΍ͬͨͥʂ

Slide 36

Slide 36 text

ຊ൪؀ڥʹ൓ө

Slide 37

Slide 37 text

ຊ൪؀ڥʹ൓ө ຊ൪؀ڥʹ΋ಉ༷ͷઃఆΛ൓ө ΫΤϦ࣮ߦ࣌ؒͷ্ݶ͕NT ͱͳΓ༧๷ઢΛுΕͨ ूܭ

Slide 38

Slide 38 text

ຊ൪؀ڥʹ൓ө ΍ͬͨͥʂʂʂʂʂ

Slide 39

Slide 39 text

ຊ൪؀ڥʹ൓ө w DPOWFOJFODF@TUPSFTJOEFYͳ Ͳ͸كʹॲཧ͕தஅ͞ΕΔ w ୹ظؒʹΫΤϦΛԿճ΋ൃߦ͞ ΕΕ͹$16ʹෛՙ͕͔͔Δ ूܭ ࢒՝୊

Slide 40

Slide 40 text

ຊ൪؀ڥʹ൓ө Զͨͪͷઓ͍͸ଓ͘ʜ

Slide 41

Slide 41 text

·ͱΊ

Slide 42

Slide 42 text

·ͱΊ w NBY@FYFDVUJPO@UJNFͰ୹ظؒͰো֐༧๷Ͱ͖Δ w ෳ਺ͷ&$4λεΫؒͰ3%41SPYZΛ࢖༻͍ͯ͠Δ࣌͸ .Z42-ͷγεςϜม਺͕ڞ༗͞Εͯ͠·͏͜ͱ͕͋Δ

Slide 43

Slide 43 text

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ