Upgrade to Pro — share decks privately, control downloads, hide ads and more …

put_the_image_in_the_rdb_advantages_and_disadva...

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for mamy1326 mamy1326
August 08, 2017
Programming
1.2k
1

 put_the_image_in_the_rdb_advantages_and_disadvantages

PHP BLT #8 で発表したスライドです

Avatar for mamy1326

mamy1326

August 08, 2017

More Decks by mamy1326

See All by mamy1326
PHPer が知るべき MySQL クエリチューニング/What PHPers Need to Know about MySQL Query Tuning
Avatar for mamy1326 mamy1326
18
7.9k
戦って品質保証を勝ち取る/Fight_for_quality_assurance
Avatar for mamy1326 mamy1326
2
920
MySQLでGROUP BY と ORDER BY を同時に使いたくなったら/If_you_want_to_use_GROUP_BY_and_ORDER_BY_at_the_same_time_in_mysql
Avatar for mamy1326 mamy1326
4
6.3k
初めてのMySQLパフォーマンスチューニングーデータベースは怖くない！/mysql-performance-tuning-basics-in-db-study-chugoku-chiho
Avatar for mamy1326 mamy1326
8
2.9k
アウトプットを継続するためにやる10箇条-吉祥寺.pm-/10_things_practicing_to_continue_output-in_kichijoji.pm
Avatar for mamy1326 mamy1326
4
2.4k
MySQLパフォーマンスチューニングの基本ー実際のトラブルシュートから my.cnf までー/MySQL_Performance_Tuning_Basics_in_OSC_Niigata
Avatar for mamy1326 mamy1326
2
3.8k
アウトプットを継続するためにやっている 10 のこと/10_things_practicing_to_continue_output
Avatar for mamy1326 mamy1326
21
9.7k
アプリケーションエンジニアが知るべきDNSの基本/Basics_of_DNS_that_application_engineers_should_know
Avatar for mamy1326 mamy1326
113
47k
dns-penetration-problem-why-can-not-i-say-penetration-kichijojipm15
Avatar for mamy1326 mamy1326
5
3.7k

Other Decks in Programming

See All in Programming
SPMマルチモジュールで テストカバレッジを取得する技法
Avatar for yosshi yosshi4486
0
140
OSもどきOS
Avatar for Sora Arakawa arkw
0
400
Lessons from Spec-Driven Development
Avatar for Simon Martinelli simas
PRO
0
120
jQueryをバージョンアップする前に使いたいjQuery Migrate
Avatar for Atsushi Matsuo matsuo_atsushi
0
170
Make SRE Operations Easier with Azure SRE Agent
Avatar for KAMEGAWA Kazushi kkamegawa
0
3.2k
Copilot CLI の継戦能力を高める コンテキスト管理
Avatar for Nozomuts nozomutu
1
1.2k
エージェンティックRAGにAWSで入門しよう！
Avatar for Har1101 har1101
4
110
IBM Bobを活用したレガシーアプリの最新化
Avatar for Akira Onishi (IBM) oniak3ibm
PRO
1
160
New "Type" system on PicoRuby
Avatar for pocke pocke
1
430
These Five Tricks Can Make Your Apps Greener, Cheaper, & Nicer
Avatar for Holly Cummins hollycummins
0
270
権限チェックの一貫性を型で守る TypeScript による多層防御
Avatar for aster-mnch (kitagawa) mnch
4
1.1k
Old Dog, New Tricks: The Java 25 Reinvention - JNation
Avatar for A N M Bazlur Rahman bazlur_rahman
0
140

Featured

See All Featured
10 Git Anti Patterns You Should be Aware of
Avatar for Lemi Orhan Ergin lemiorhan
PRO
659
62k
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
32
2.9k
RailsConf 2023
Avatar for Aaron Patterson tenderlove
30
1.5k
It's Worth the Effort
Avatar for 3n 3n
188
29k
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
Avatar for Liv Day livdayseo
0
130
Designing for Performance
Avatar for Lara Hogan lara
611
70k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
Designing Experiences People Love
Avatar for Jonathan Moore moore
143
24k
GraphQLとの向き合い方2022年版
Avatar for Yosuke Kurami quramy
50
15k
職位にかかわらず全員がリーダーシップを発揮するチーム作り / Building a team where everyone can demonstrate leadership regardless of position
Avatar for MADOX madoxten
62
54k
Skip the Path - Find Your Career Trail
Avatar for Mark Kilby mkilby
1
140
Helping Users Find Their Own Way: Creating Modern Search Experiences
Avatar for Dan Newman danielanewman
31
3.2k

Transcript

  1. ը૾Λ3%#ʹ ΩϟοΩϟ΢ϑϑ͢Δ ϝϦοτσϝϦοτ *OOPWBUPS+BQBO*OD ·Έ΍ͳ͓͖ !NBNZ  "VH!1)1#-5

  2. ۙگ

  3. ۙگ - ࠷ۙPHPॻ͍ͯ·ͤΜʂ - builderscon Ͱ ɹొஃ & ϘϥϯςΟΞελοϑ ɹɹ͖ͯ͠·ͨ͠

  4. ͱ͜ΖͰ Έͳ͞Μ

  5. ը૾Λ3%#ʹ ΩϟοΩϟ΢ϑϑ Ҋ݅

  6. ܦݧͨ͜͠ͱ ͋Γ·͔͢ʁ ڍख✋

  7. ๻͸͋Γ·͢ʂ

  8. ͭΒ͍

  9. Ͱ΋ ඞཁͳ࣌͸ ͋Δ͔΋͠Εͳ͍

  10. Զ͕ࢮΜͩΒʜ ͋ͷൿଂͷը૾ ϑΥϧμΛʜ

  11. ࡟আͯ͠ʜ ͓͔ʜͶ͹ʜ ŰƄŦŕ@ ʯ㲃 @

  12. Ͱ΋҆৺ ͓ๅը૾ %#ͷதͳΒͶ

  13. ͑ʁ ͦΕͰ͍͍ͷʁ

  14. ͍͍Θ͚ Ͷ͐ͩΖ͏

  15. ͱ͍͏Θ͚Ͱ ϝϦοτσϝϦοτʂ

  16. ൃ୺ ⾣UFSBUBJMͰ౴͑ͨ IUUQTUFSBUBJMDPNRVFTUJPOT

  17. ൃ୺ ⾣ϕετΞϯαʔʹͳͬͨ

  18. ൃ୺ ⾣5XJUUFSʹ౤ߘͨ͠

  19. ൃ୺ ⾣ΊͬͪΌ੝Γ্͕ͬͨ

  20. ൃ୺ ⾣·ͱΊͨ IUUQTUPHFUUFSDPNMJ

  21. ϝϦοτ ▶︎ τϥϯβΫγϣϯͷԸܙ ▶︎ ҉߸ԽͱηΩϡϦςΟ ▶︎ όοΫΞοϓͷू໿ੑ ▶︎ ؂ࠪʢཤྺʣͷ౷߹తͳ࣮૷

  22. ɹτϥϯβΫγϣϯͷԸܙ ⾣ΞοϓϩʔυޙͷࣦഊෆՄආ ɹˠSPMMCBDLͰҰൃͰͳ͔ͬͨ͜ͱʹ ϑΝϯτϜϑΝΠϧͷ ๷ࢭʹͳΔ

  23. ɹ҉߸ԽͱηΩϡϦςΟ ⾣Χϧςͷఴ෇ը૾ͳͲ ɹˠඇৗʹηϯγςΟϒͳը૾ ҉߸ԽɾηΩϡΞʹ औΓѻ͏

  24. ɹόοΫΞοϓͷू໿ੑ ⾣%#όοΫΞοϓ͚ͩͰ ɹˠը૾΋όοΫΞοϓ͞ΕΔ ͔͠͠4ͷొ৔Ͱ ϝϦοτ͸ແ͘ͳͬͨ

  25. ɹ؂ࠪ ཤྺ ͷ౷߹తͳ࣮૷ ⾣ը૾ͷߋ৽ཤྺΛऔΓ͍ͨ ɹˠόʔδϣϯ؅ཧ΋͍ͨ͠ ύϑΥʔϚϯεΛ٘ਜ਼ʹͯ͠΋ ࣮૷͍ͨ͠ͳΒ0,

  26. σϝϦοτ ▶︎ ύϑΥʔϚϯε௿Լ ▶︎ DBͷετϨʔδѹഭ ▶︎ ωοτϫʔΫΛѹഭ ▶︎ ը૾ΛDB͔Β෼ׂ࣌ͷฐ֐ ▶︎

    ϝϯςφϯεੑͷ௿Լ ▶︎Ωϟογϡ͠ʹ͍͘

  27. ɹύϑΥʔϚϯε௿Լ ⾣ը૾σʔλΛϨίʔυʹؚΉ ɹˠσʔλྔ૿Ճ38͕஗͘ ύϑΥʔϚϯε௿ԼΛ ཁ্͕݅ճΔ৔߹ͷΈ

  28. ɹ%#ͷετϨʔδѹഭ ⾣૝ఆΛ௒͑ͨσʔλ૿Ճ ɹˠཁ݅௥Ճ αϜωΠϧɺผͷը૾௥Ճ  ͪΐͬͱͨ͠௥Ճ͕ কདྷతʹετϨʔδΛѹഭ

  29. ɹωοτϫʔΫΛѹഭ ⾣ը૾Λ%#͔Βऔಘ ɹˠωοτϫʔΫѹഭ XFC%#ؒ  ଴͕ͪൃੜ͠ Ϩεϙϯε͕௿Լ

  30. ɹը૾Λ%#͔Β෼ׂ࣌ͷฐ֐ ⾣੩తϑΝΠϧΛઐ༻αʔόʔ΁ ɹˠશϨίʔυҠߦɺύε৘ใ௥Ճ ؆୯ʹ෼ׂɺҠಈͰ͖ͣ σʔλྔ࣍ୈͰ͕͔͔࣌ؒΔ

  31. ɹϝϯςφϯεੑͷ௿Լ ⾣ը૾ߋ৽͸Ξοϓͨ͠ΒऴΘΓ ɹˠ%#ͩͱϓϩάϥϜɺ42-Λ௨͢ Կஈ֊΋ ༨ܭͳखॱΛ౿Ή

  32. ɹΩϟογϡ͠ʹ͍͘ ⾣%#อଘͷը૾Λʜ ɹˠΩϟογϡͤ͞Δ࢓૊Έ͕ඞཁ ӡ༻ޮ཰ɺอकੑ͕௿Լ

  33. ɹ·ͱΊ ⾣ಛघͳཁ݅ͷ৔߹ʹ࢖͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃ޻਺ɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮૷Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷ੹຿Λߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ

  34. ɹ·ͱΊ ⾣ಛघͳཁ݅ͷ৔߹ʹ࢖͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃ޻਺ɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮૷Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷ੹຿Λߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ

  35. ɹ·ͱΊ ⾣ಛघͳཁ݅ͷ৔߹ʹ࢖͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃ޻਺ɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮૷Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷ੹຿Λߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ

  36. ɹ·ͱΊ ⾣ಛघͳཁ݅ͷ৔߹ʹ࢖͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃ޻਺ɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮૷Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷ੹຿Λߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ

  37. σʔλͷण໋͸ ΞϓϦΑΓ௕͍ͧ

  38. ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ