Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
管理画面とユーザー機能の調和を取り戻す!~クエリパフォーマンス改善の成功物語~ / Resto...
Search
koki otaka
October 17, 2024
Technology
1
670
管理画面とユーザー機能の調和を取り戻す!~クエリパフォーマンス改善の成功物語~ / Restore harmony between administrative and user functions!
koki otaka
October 17, 2024
Tweet
Share
More Decks by koki otaka
See All by koki otaka
CSとエンジニアをつなぐ新戦略: Embedded CRE 導入事例 / Embedded CRE Case Study
minisera
0
35
Other Decks in Technology
See All in Technology
Platform Engineeringで クラウドの「楽しくない」を解消しよう
jacopen
4
120
Potential EM 制度を始めた理由、そして2年後にやめた理由 - EMConf JP 2025
hoyo
2
2.9k
AI Agent時代なのでAWSのLLMs.txtが欲しい!
watany
3
340
エンジニア主導の企画立案を可能にする組織とは?
recruitengineers
PRO
1
280
開発者のための FinOps/FinOps for Engineers
oracle4engineer
PRO
2
210
【詳説】コンテンツ配信 システムの複数機能 基盤への拡張
hatena
0
280
EDRの検知の仕組みと検知回避について
chayakonanaika
12
5.2k
Aurora PostgreSQLがCloudWatch Logsに 出力するログの課金を削減してみる #jawsdays2025
non97
1
230
JAWS FESTA 2024「バスロケ」GPS×サーバーレスの開発と運用の舞台裏/jawsfesta2024-bus-gps-serverless
ma2shita
3
280
Snowflake ML モデルを dbt データパイプラインに組み込む
estie
0
110
Two Blades, One Journey: Engineering While Managing
ohbarye
4
2.3k
サイト信頼性エンジニアリングとAmazon Web Services / SRE and AWS
ymotongpoo
7
1.7k
Featured
See All Featured
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
44
7k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
356
29k
How to Ace a Technical Interview
jacobian
276
23k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
231
53k
GitHub's CSS Performance
jonrohan
1030
460k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
29
1k
Code Review Best Practice
trishagee
67
18k
Embracing the Ebb and Flow
colly
84
4.6k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
507
140k
The World Runs on Bad Software
bkeepers
PRO
67
11k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
4
440
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
7
650
Transcript
ཧը໘ͱϢʔβʔػೳͷௐΛऔΓ͢ʂ dΫΤϦύϑΥʔϚϯεվળͷޭޠd 
💯
%#ͷ$16༻😇
োಥવͬͯ͘Δ ຊ൪ڥʹͯΞϓϦ͚ͷ"1*ܾࡁ༻"1*ͷ ύϑΥʔϚϯε͕Ұ࣌తʹѱԽ͢ΔোΛ֬ೝ ௐࠪͷ݁Ռɺཧը໘͔Βൃߦ͞ΕΔΫΤϦ͕ %#ͷ$16Λѹഭ͍ͯͨ͜͠ͱ͕ݪҼ
োಥવͬͯ͘Δ ͋ͳͨͳΒͲ͏ରԠ͠·͔͢ʁ😇
4NBSU#BOL *OD $3& αʔόʔαΠυΤϯδχΞ େߴޫؾ ͓͓͔ͨ͜͏͖ !PI@NJOJTFSB !NJOJTFSB τϐοΫ
w ࠓͷ݄͔Β4NBSU#BOL+PJO w ৽ଔҰࣾཧֶྍ๏࢜ɺΤϯδχΞྺ w ਓੜॳొஃͰzۓுzʜ
X
োಥવͬͯ͘Δ
োಥવͬͯ͘Δ
োಥવͬͯ͘Δ ຊ൪ڥʹͯΞϓϦ͚ͷ"1*ܾࡁ༻"1*ͷ ύϑΥʔϚϯε͕Ұ࣌తʹѱԽ͢ΔোΛ֬ೝ ௐࠪͷ݁Ռɺཧը໘͔Βൃߦ͞ΕΔΫΤϦ͕ %#ͷ$16Λѹഭ͍ͯͨ͜͠ͱ͕ݪҼ
োಥવͬͯ͘Δ ݪҼ # " 😇 😇 😇 😇 😇
ཧը໘
ղܾํ
ʢཧը໘ʣݱঢ়ͷ"1*ͱΫΤϦͷ࣌ؒΛચ͍ग़͢ ղܾํ ूܭ
ղܾํ શͯ͢ͷແཧͦ͏ʜ
ղܾํ ظؒͰΒͶʜ
ղܾํ w ϘτϧωοΫͱͳΔ"1*ʹߜΓमਖ਼ w ཧը໘ಛ༗ͷεΩϟϯྔͷଟ͍ΫΤϦΛશ͖ͯ͠Εͳ͍ w ظؒͰোΛ༧͢Δ w ଞλεΫͱͷ݉Ͷ߹͍
ղܾํ w ϘτϧωοΫͱͳΔ"1*ͷվम w NBY@FYFDVUJPO@UJNFͷઃఆʢຊͷϝΠϯʣ
ղܾํ w .Z42-ͷγεςϜมͷҰͭ w 4&-&$5ͷ࣮ߦλΠϜΞτΛઃఆͰ͖ΔʢϛϦඵʣ NBY@FYFDVUJPO@UJNFͱ
ղܾํ ᮢʢNBY@FYFDVUJPO@UJNFʹઃఆ͢Δʣͱ मਖ਼"1*ΛܾΊΔ "1*ͷमਖ਼ ཧը໘ʹͷΈNBY@FYFDVUJPO@UJNFΛઃఆ͢Δ
ᮢͱमਖ਼"1*ΛܾΊΔ
ʢཧը໘ʣݱঢ়ͷ"1*ͱΫΤϦͷ࣌ؒΛચ͍ग़͢ ᮢͱमਖ਼"1*ΛܾΊΔ ूܭ
ᮢͱमਖ਼"1*ΛܾΊΔ w HNP@BP[PSB@WJSUVBM@BDDPVOU TJOEFY·Ͱ͕ݱ࣮తͳमਖ਼Մ ೳͳ"1*ʢຊʣ w NBY@FYFDVUJPO@UJNFඵ
NBY@FYFDVUJPO@UJNFͷઃఆ
3BJMTͰͷઃఆ NBY@FYFDVUJPO@UJNFͷઃఆ DPSFBQJ
3BJMTͰͷઃఆ NBY@FYFDVUJPO@UJNFͷઃఆ ཧը໘ͷΫΤϦͷΈద༻͍ͨ͠
NBY@FYFDVUJPO@UJNFͷઃఆ # " ཧը໘͚ͩʹઃఆ͍ͨ͠
3BJMTͰͷઃఆ NBY@FYFDVUJPO@UJNFͷઃఆ DPSFBQJ
NBY@FYFDVUJPO@UJNFͷઃఆ w ·Βʹઃఆ͞Ε͍ͯΔ w Ϣʔβʔ͚ΞϓϦʹ NBY@FYFDVUJPO@UJNF͕ ઃఆ͞Ε͍ͯΔ ݕূڥͰͷಈ࡞֬ೝ 👍
# " 👍 👎
NBY@FYFDVUJPO@UJNFͷઃఆ ͳΜͰ🥺
NBY@FYFDVUJPO@UJNFͷઃఆ 3%41SPYZͷઃఆݟ͠
NBY@FYFDVUJPO@UJNFͷઃఆ 3%41SPYZͷઃఆݟ͠ # " ઃఆ༗ ίωΫγϣϯϓʔϧ ઃఆແ ઃఆ༗ #FGPSF
ཧը໘
NBY@FYFDVUJPO@UJNFͷઃఆ 3%41SPYZͷઃఆݟ͠ # " ίωΫγϣϯϓʔϧ ઃఆແ ઃఆແ ઃఆແ "GUFS
ཧը໘
NBY@FYFDVUJPO@UJNFͷઃఆ w ظ௨Γཧը໘ͷΈʹ ઃఆ͞ΕΔ ݕূڥͰͷಈ࡞֬ೝ 👍 # " 👍
👍
NBY@FYFDVUJPO@UJNFͷઃఆ ͬͨͥʂ
ຊ൪ڥʹө
ຊ൪ڥʹө ຊ൪ڥʹಉ༷ͷઃఆΛө ΫΤϦ࣮ߦ࣌ؒͷ্ݶ͕NT ͱͳΓ༧ઢΛுΕͨ ूܭ
ຊ൪ڥʹө ͬͨͥʂʂʂʂʂ
ຊ൪ڥʹө w DPOWFOJFODF@TUPSFTJOEFYͳ Ͳكʹॲཧ͕தஅ͞ΕΔ w ظؒʹΫΤϦΛԿճൃߦ͞ ΕΕ$16ʹෛՙ͕͔͔Δ ूܭ ՝
ຊ൪ڥʹө Զͨͪͷઓ͍ଓ͘ʜ
·ͱΊ
·ͱΊ w NBY@FYFDVUJPO@UJNFͰظؒͰো༧Ͱ͖Δ w ෳͷ&$4λεΫؒͰ3%41SPYZΛ༻͍ͯ͠Δ࣌ .Z42-ͷγεςϜม͕ڞ༗͞Εͯ͠·͏͜ͱ͕͋Δ
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ