Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

put_the_image_in_the_rdb_advantages_and_disadva...

Avatar for mamy1326 mamy1326
August 08, 2017
Programming
1.3k
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
8.1k
戦って品質保証を勝ち取る/Fight_for_quality_assurance
Avatar for mamy1326 mamy1326
2
940
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.4k
初めてのMySQLパフォーマンスチューニングーデータベースは怖くない！/mysql-performance-tuning-basics-in-db-study-chugoku-chiho
Avatar for mamy1326 mamy1326
8
3k
アウトプットを継続するためにやる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
48k
dns-penetration-problem-why-can-not-i-say-penetration-kichijojipm15
Avatar for mamy1326 mamy1326
5
4.1k

Other Decks in Programming

See All in Programming
UnityでSystem.Net.WebSocketsなWebSocketサーバが動かないのでUnity Monoのコードを覗いてみた / about implementing websocket server with unity mono
Avatar for にー兄さん drumath2237
1
560
phperだってパンチカードでコーディングしたい
Avatar for hideki kinjyo o0h
PRO
0
240
Augmenting AI with the Power of Jakarta EE
Avatar for ivargrimstad ivargrimstad
0
570
iOS 27でニュースアプリはどう変わる！？ 〜日経電子版の新機能対応と、開発事例から〜
Avatar for Kazuki Nakashima lynnswap
7
13k
気持ちぃ〜角丸 Squircle
Avatar for ryu ryu1013
0
130
Augmenting AI with the Power of Jakarta EE
Avatar for ivargrimstad ivargrimstad
0
500
ハーネス設計入門 〜 基礎知識の整理から実務へのステップアップ 〜
Avatar for kinopee kinopeee
21
21k
Everything will be SERVERLESS — 信じて運用した10年の経験値 / Everything Will be Serverless — Lessons Learned from 10 Years of Operational Experience
Avatar for shiro seike seike460
PRO
1
850
Rでドレミ/Do-Re-Mi_with_R
Avatar for florets1 florets1
0
130
自サークルのIdPからログアウトできるようになるまで
Avatar for taiseiue taiseiue
1
120
Vue Fes Japan 2026 タイムテーブル徹底解説
Avatar for 448jp | OKI Yoshiya 448jp
1
640
ソニーのクラウド共通基盤の変遷と AI時代の開発スタイルに合わせた進化 / The Journey of Sony’s Common Cloud Platform and Its Evolution for AI-Native Development
Avatar for KenjiYoneyama kenjiyoneyama
0
240

Featured

See All Featured
SEO in 2025: How to Prepare for the Future of Search
Avatar for Michael King ipullrank
3
3.9k
The Hidden Cost of Media on the Web [PixelPalooza 2025]
Avatar for Tammy Everts tammyeverts
2
510
[SF Ruby Conf 2025] Rails X
Avatar for Vladimir Dementyev palkan
3
1.4k
WENDY [Excerpt]
Avatar for Tessa Abrams tessaabrams
14
40k
技術選定の審美眼（2025年版） / Understanding the Spiral of Technologies 2025 edition
Avatar for Takuto WADA twada
PRO
120
120k
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
34
9.8k
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
Avatar for Ines Montani inesmontani
PRO
3
2.4k
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
3
1.3k
Art, The Web, and Tiny UX
Avatar for Lynn Fisher lynnandtonic
304
22k
Efficient Content Optimization with Google Search Console & Apps Script
Avatar for Katarina Dahlin katarinadahlin
PRO
1
910
Reality Check: Gamification 10 Years Later
Avatar for Sebastian Deterding codingconduct
0
2.3k
Exploring anti-patterns in Rails
Avatar for Elle Meredith aemeredith
4
530

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. ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ