put_the_image_in_the_rdb_advantages_and_disadvantages

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

Transcript

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

   View Slide

2. ۙگ
   

   View Slide

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

   View Slide

4. ͱ͜ΖͰ
   Έͳ͞Μ
   

   View Slide

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

   View Slide

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

   View Slide

7. ๻͸͋Γ·͢ʂ
   

   View Slide

8. ͭΒ͍
   

   View Slide

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

   View Slide

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

    View Slide

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

    View Slide

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

    View Slide

13. ͑ʁ
    ͦΕͰ͍͍ͷʁ
    

    View Slide

14. ͍͍Θ͚
    Ͷ͐ͩΖ͏
    

    View Slide

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

    View Slide

16. ൃ୺
    ⾣UFSBUBJMͰ౴͑ͨ
    IUUQTUFSBUBJMDPNRVFTUJPOT
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

20. ൃ୺
    ⾣·ͱΊͨ
    IUUQTUPHFUUFSDPNMJ
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

26. σϝϦοτ
    ▶︎ ύϑΥʔϚϯε௿Լ
    ▶︎ DBͷετϨʔδѹഭ
    ▶︎ ωοτϫʔΫΛѹഭ
    ▶︎ ը૾ΛDB͔Β෼ׂ࣌ͷฐ֐
    ▶︎ ϝϯςφϯεੑͷ௿Լ
    ▶︎Ωϟογϡ͠ʹ͍͘
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide