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

put_the_image_in_the_rdb_advantages_and_disadva...

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for mamy1326 mamy1326
August 08, 2017
Programming
1
1.2k

 put_the_image_in_the_rdb_advantages_and_disadvantages

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

Avatar for mamy1326

mamy1326

August 08, 2017
Tweet

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.8k
戦って品質保証を勝ち取る/Fight_for_quality_assurance
Avatar for mamy1326 mamy1326
2
890
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.3k
MySQLパフォーマンスチューニングの基本ー実際のトラブルシュートから my.cnf までー/MySQL_Performance_Tuning_Basics_in_OSC_Niigata
Avatar for mamy1326 mamy1326
2
3.7k
アウトプットを継続するためにやっている 10 のこと/10_things_practicing_to_continue_output
Avatar for mamy1326 mamy1326
21
9.6k
アプリケーションエンジニアが知るべき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.6k

Other Decks in Programming

See All in Programming
ZJIT: The Ruby 4 JIT Compiler / Ruby Release 30th Anniversary Party
Avatar for Takashi Kokubun k0kubun
1
390
Vibe codingでおすすめの言語と開発手法
Avatar for uyuki uyuki234
0
200
.NET Conf 2025 の興味のあるセッ ションを復習した / dotnet conf 2025 quick recap for backend engineer
Avatar for Tomohisa Takaoka tomohisa
0
120
ThorVG Viewer In VS Code
Avatar for Nor-s nors
0
750
Basic Architectures
Avatar for Denys Poltorak denyspoltorak
0
630
16年目のピクシブ百科事典を支える最新の技術基盤 / The Modern Tech Stack Powering Pixiv Encyclopedia in its 16th Year
Avatar for ahu ahuglajbclajep
5
940
AI によるインシデント初動調査の自動化を行う AI インシデントコマンダーを作った話
Avatar for azukiazusa azukiazusa1
1
580
フロントエンド開発の勘所 -複数事業を経験して見えた判断軸の違い-
Avatar for Yoichiro Kubo heimusu
7
2.7k
QAフローを最適化し、品質水準を満たしながらリリースまでの期間を最短化する #RSGT2026
Avatar for shibayu36 shibayu36
2
4.1k
Oxlintはいいぞ
Avatar for Yuji Yamaguchi yug1224
5
1.1k
なるべく楽してバックエンドに型をつけたい！(楽とは言ってない)
Avatar for HIBIKI CUBE hibiki_cube
0
130
Honoを使ったリモートMCPサーバでAIツールとの連携を加速させる！
Avatar for とすり tosuri13
1
170

Featured

See All Featured
A better future with KSS
Avatar for Kyle Neath kneath
240
18k
It's Worth the Effort
Avatar for 3n 3n
188
29k
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
239
140k
Building a A Zero-Code AI SEO Workflow
Avatar for Ian Lurie portentint
PRO
0
270
Organizational Design Perspectives: An Ontology of Organizational Design Elements
Avatar for Dr. Kim W Petersen kimpetersen
PRO
1
69
How to build an LLM SEO readiness audit: a practical framework
Avatar for Nick Samuel nmsamuel
1
630
How To Speak Unicorn (iThemes Webinar)
Avatar for Michelle Schulp Hunt marktimemedia
1
370
How People are Using Generative and Agentic AI to Supercharge Their Products, Projects, Services and Value Streams Today
Avatar for Helen Beal helenjbeal
1
100
How to Align SEO within the Product Triangle To Get 
Buy-In & Support - #RIMC
Avatar for Aleyda Solis aleyda
1
1.4k
End of SEO as We Know It (SMX Advanced Version)
Avatar for Michael King ipullrank
2
3.9k
Abbi's Birthday
Avatar for Violet Bock coloredviolet
1
4.5k
Evolving SEO for Evolving Search Engines
Avatar for Ryan Jones ryanjones
0
110

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