Slide 1

Slide 1 text

Monday, September 3, 12

Slide 2

Slide 2 text

whoami ★Twitter: a_matsuda ★GitHub: amatsuda Monday, September 3, 12

Slide 3

Slide 3 text

Monday, September 3, 12

Slide 4

Slide 4 text

begin Monday, September 3, 12

Slide 5

Slide 5 text

Forkwellͬͯ ͳΜ͔஗͍Ͱ͢ΑͶʁ Monday, September 3, 12

Slide 6

Slide 6 text

WHO SLOW? ★server side ★network ★client side Monday, September 3, 12

Slide 7

Slide 7 text

WHO SLOW? - server side ★infra ★code Monday, September 3, 12

Slide 8

Slide 8 text

infra ★AP server ★DB Monday, September 3, 12

Slide 9

Slide 9 text

AP Server ★Passenger vs Unicorn Monday, September 3, 12

Slide 10

Slide 10 text

Passenger > Unicorn ? “ͳͥ Forkwell ͸ϦϦʔεॳ೔ʹ αʔόμ΢ϯΛ܁Γฦͨ͠ͷ͔“ http://annex-forkwell.heroku.com/2012/04/12/ server_failure Monday, September 3, 12

Slide 11

Slide 11 text

͢·Μͳɻ͋Ε͸ӕͩ Unicorn଎͍Θʔ (ͨͩ͠ɺRails͕ ݩؾʹಈ͍͍ͯΔݶΓ͸) Monday, September 3, 12

Slide 12

Slide 12 text

DB ★ CPU࢖༻཰͕(ͨ·ʹ)όΫϋπ ★ ͦΜͳෳࡶͳܭࢉͯ͠ΔΑ͏ͳΞϓϦ͡Ό ͳ͍ͷͰDBαʔόʔͷCPU࢖͏ͳΜͯ໌Β ͔ʹ͓͔͍͠ Monday, September 3, 12

Slide 13

Slide 13 text

DB ★full scan... ★indexுΓ๨ΕͯΔΑ... Monday, September 3, 12

Slide 14

Slide 14 text

% rails g ★ e.g. when Post has_many Comments ★ % rails g model comment post:references body:text - indexed ★ % rails g migration add_user_id_to_comment user_id:integer - not indexed Monday, September 3, 12

Slide 15

Slide 15 text

PROTIP: ϚΠάϨʔγϣϯͰΧϥϜ௥Ճ ͢Δͱ͖͸index΋๨Εͣʹʂ Monday, September 3, 12

Slide 16

Slide 16 text

code ★Ruby ★Rails Monday, September 3, 12

Slide 17

Slide 17 text

Ruby ★Ruby 1.9.3 Monday, September 3, 12

Slide 18

Slide 18 text

Ruby 1.9.3 ଎͍ΑͶʁ Monday, September 3, 12

Slide 19

Slide 19 text

Rails ★Rails 3.2.8 Monday, September 3, 12

Slide 20

Slide 20 text

ී௨ʹ࠷৽ͷRailsΛ࢖͍ͬͯͨͩ ͚Ͱୡ੒Ͱ͖͍ͯͨ͜ͱ ★Asset Pipeline Monday, September 3, 12

Slide 21

Slide 21 text

Asset Pipeline ★assets͸WEBαʔόʔͰ ★.scss => .css, .coffee => .js ΛϓϦ ίϯύΠϧ ★*.js, *.cssΛ1ϑΝΠϧʹ݁߹ Monday, September 3, 12

Slide 22

Slide 22 text

ʮRails͔ͩΒ଎͍ʯ ࣌୅ Monday, September 3, 12

Slide 23

Slide 23 text

slow code ★slow query ★N+1 queries ★“Activity” Monday, September 3, 12

Slide 24

Slide 24 text

slow query ★ ࠷ۙ୭͔ͷΞΫςΟϏςΟ͕͋ͬͨεΩϧλάͷ TOP 20-ish(20݅͝ͱʹϖʔδωʔγϣϯ) ★ ↑ͷͦΕͧΕͷεΩϧλά͝ͱʹ(ࣗ෼ͷ༑ͩͪͷ)୭ ͔͕௚ۙ7೔ؒҎ಺ʹߦͬͨΞΫςΟϏςΟͷ࠷৽6 ݅(ͨͩ͠ʮ+1͠·ͨ͠ʯͱʮಡΜͩΑʯ͸࠷৽ͷ΋ ͷͷΈ)ʹ͍ͭͯɺ୭͕(FBʹొ࿥͞ΕͯΔݱࡏͷϩ έʔϧͷϑϧωʔϜ + ΞΠίϯը૾)ԿΛͲ͏͔ͨ͠ (I18nͭͭ͠)දࣔɻ7݅Ҏ্͋Δ৔߹͸ʮ΋ͬͱݟ ΔʯϘλϯΛදࣔɻ Monday, September 3, 12

Slide 25

Slide 25 text

τοϓϖʔδͰൃߦ͞ΕΔSQL ★before: SQL਺ඦൃ ★after: 2 SQLs Monday, September 3, 12

Slide 26

Slide 26 text

SQL quiz ύϒϦέʔγϣϯ͝ͱʹgroup by ͨ͠άϧʔϓ͝ͱʹ order by + limitͰ࠷৽ͷΞΫςΟϏςΟΛ6 ݅ͣͭऔಘɺ͍ͭͰʹʮ΋ͬͱݟ Δʯ͔Ͳ͏͔΋஌Γ͍ͨ Monday, September 3, 12

Slide 27

Slide 27 text

use vendor speci c SQL # -*- coding: utf-8 -*- class Activity < ActiveRecord::Base ... # ड͚औͬͨactivitiesΛɺpublication_idͷ஋͝ͱʹ࠷େ7݅ͣͭʹߜͬͯฦ͢ # [MySQLݶఆ] def self.select_top_7_per_publication_id(activities) # ࠷৽ͷ6+1݅(see moreΛදࣔ͢Δ͔Ͳ͏͔Λ൑ఆ͢ΔͨΊʹ׶͑ͯ1݅ଟΊʹऔಘ) Activity.from(<<-SQL).where("activities.row_number <= #{DISPLAY_ACTIVITY_NUM + 1}") (select *, if(@previous_publication_id <> publication_id, @rownum := 1, @rownum := @rownum + 1) as row_number, @previous_publication_id := publication_id from (#{activities.to_sql}) as a cross join (select @rownum := NULL, @previous_publication_id := 0) as r order by publication_id, id desc ) AS activities SQL end ... end ΩϞ͍ Monday, September 3, 12

Slide 28

Slide 28 text

ੜSQL্౳ ★ ARͷύϑΥνϡʔ͸ੜSQLॻ͍ͯ ͳΜ΅ ★ Ή͠ΖARͷ୉ޣຯ͸ੜSQLͱͷڞଘ (ͬͯMartin Fowler΋ݴͬͯͨ) ★ ՄಡੑɾอकੑͱύϑΥʔϚϯεͷ τϨʔυΦϑ Monday, September 3, 12

Slide 29

Slide 29 text

ṖSQLϩδοΫ ★scopeʹด͡ࠐΊͯ ★ద੾ͳ໊લΛ෇͚ͯ ★୯ମςετͰ୲อ Monday, September 3, 12

Slide 30

Slide 30 text

use AR::Relation ★AR::Relation#merge ★AR::Relation#to_sql Monday, September 3, 12

Slide 31

Slide 31 text

PROTIP: ੜSQLສࡀ Monday, September 3, 12

Slide 32

Slide 32 text

PROTIP: use PostgreSQL Monday, September 3, 12

Slide 33

Slide 33 text

N+1 queries ★Bullet https://github.com/ yerhzm/ bullet ★৭ʑڭ͑ͯ͘ΕΔͷͰɺ(ಛʹ SQL͕͋·Γಘҙ͡Όͳ͍ਓʹ ͸)ศར͔΋Ͷ Monday, September 3, 12

Slide 34

Slide 34 text

PROTIP: use Bullet (if you need) Monday, September 3, 12

Slide 35

Slide 35 text

“Activity” Monday, September 3, 12

Slide 36

Slide 36 text

WUT SLOW? ★ܭଌ͠Α͏ʂ Monday, September 3, 12

Slide 37

Slide 37 text

rack-mini-pro ler ★rack-mini-pro ler https:// github.com/SamSaffron/ MiniPro ler/tree/master/Ruby ★(demo) Monday, September 3, 12

Slide 38

Slide 38 text

“Activity” ★ ࣮ߦऀͷFBΞΠίϯը૾ ★ ͳΜ͔ෳࡶͰॏ͍ͨۀ຿ϩδοΫΛܦͯ ग़͖ͯͨจݴΛI18nͨ͠΋ͷ ★ Ұ౓࡞ΒΕͨΒมΘΒͳ͍ ★ ঢ়ଶ΍ϩάΠϯϢʔβʔʹΑΔมԽΛड ͚ͳ͍(I18n.localeҎ֎͸) Monday, September 3, 12

Slide 39

Slide 39 text

fragment cacheͷ ग़൪Ͱ͢Ͷɻ Monday, September 3, 12

Slide 40

Slide 40 text

Rails3ϨγϐϒοΫ 293ϖʔδ Monday, September 3, 12

Slide 41

Slide 41 text

fragment cache ͜ΕͰϖʔδશମ͕1.5ഒ଎ ͙Β͍ʹͳͬͨ Monday, September 3, 12

Slide 42

Slide 42 text

PROTIP: use fragment cache Monday, September 3, 12

Slide 43

Slide 43 text

PROTIP: ͓खݩʹҰ࡭ɺ ”Rails3ϨγϐϒοΫ” Monday, September 3, 12

Slide 44

Slide 44 text

WHO SLOW? - network Amazon EC2 + S3 Monday, September 3, 12

Slide 45

Slide 45 text

Facebook API (fb_graph) FB APIΛසൟʹୟ͘ΞϓϦͩͱ αʔόʔ͕USʹ͋Δ΄͏͕଎͍ (͜ͱ΋͋Δ) Monday, September 3, 12

Slide 46

Slide 46 text

ͱࢥͬͯαʔόʔΛUS ੢ւ؛ʹஔ͍ͯͨ Monday, September 3, 12

Slide 47

Slide 47 text

͚Ͳ΍ͬͺΓ Ͳ͏ߟ͑ͯ΋஗͍ Monday, September 3, 12

Slide 48

Slide 48 text

ͷͰࡢ೔Tokyo regionʹ Ҿͬӽ͠·ͨ͠ ★(demo) http://forkwell.com/ humans.txt Monday, September 3, 12

Slide 49

Slide 49 text

PROTIP: use AWS Tokyo region Monday, September 3, 12

Slide 50

Slide 50 text

WHO SLOW? - network ★ܭଌͯ͠ΈΔ Monday, September 3, 12

Slide 51

Slide 51 text

tools ★ PageSpeed (Google) ★ YSlow (Yahoo) ★ Chrome Developer Tools -> Audits ★ PageSpeed Insights https:// developers.google.com/speed/pagespeed/ insights ★ WEBPAGETEST http://www.webpagetest.org/ Monday, September 3, 12

Slide 52

Slide 52 text

PageSpeed ★(demo) Monday, September 3, 12

Slide 53

Slide 53 text

ݪҼͱରࡦ ★ৄ͘͠͸͜ͷ΁Μݟ͍ͯͩ͘͞ Web Performance Best Practices https://developers.google.com/ speed/docs/best-practices/ rules_intro Monday, September 3, 12

Slide 54

Slide 54 text

ରࡦ ★Optimize images ★ը૾ͷlazyload ★Defer parsing of JavaScript ★document.ready → $ -> ★CSS sprites Monday, September 3, 12

Slide 55

Slide 55 text

Optimize images ★ImageOptim http:// imageoptim.com/ Monday, September 3, 12

Slide 56

Slide 56 text

ը૾ͷlazyload FBΞΠίϯը૾ͨͪͷϩʔυ͕஗ ͗͢ΔͷͰɺ࠷ॳ͸ผͷը૾Λग़ ͓͍ͯͯ͠ޙ͔ΒJSͰࠩ͠ସ͑Δ ͱ͍͏࡞ઓ Monday, September 3, 12

Slide 57

Slide 57 text

jquery.lazyload.js jquery.lazyload.js http:// www.appelsiini.net/projects/lazyload Monday, September 3, 12

Slide 58

Slide 58 text

Defer parsing of JavaScript “Putting inline scripts after all other resources prevents blocking of other downloads, and it also enables progressive rendering.” https://developers.google.com/speed/ docs/best-practices/ rtt#PutStylesBeforeScripts Monday, September 3, 12

Slide 59

Slide 59 text

document.ready → $ -> ΠϕϯτൃՐλΠϛϯάͷ ࠷దԽ Monday, September 3, 12

Slide 60

Slide 60 text

CSS sprites ͜ΜͳͷσβΠφʔ͞Μ͕ͪ·ͪ ·΍Δ࡞ۀͰ͠ΐʁͬͯࠓ·Ͱ͸ ๻΋ࢥͬͯͨΜͰ͕͢ɺ Monday, September 3, 12

Slide 61

Slide 61 text

Compass Spriting with Compass http:// compass-style.org/help/tutorials/ spriting/ Monday, September 3, 12

Slide 62

Slide 62 text

CompassϠό͍؆୯͗ͯ͢Ϡό͍ ★ ର৅ը૾ϑΝΠϧΛద౰ͳσΟϨΫτϦʹ Ҡಈ % mkdir app/assets/images/icons % mv app/assets/images/{foo.png,bar.png,icons} ★ SCSS import "icons/*.png"; @include all-icons-sprites; ★ HTML = link_to ‘’, somewhere_path, class: 'icons-foo' Monday, September 3, 12

Slide 63

Slide 63 text

“Use a Content Delivery Network (CDN)” Monday, September 3, 12

Slide 64

Slide 64 text

Amazon CloudFront CDN S3ʹஔ͍ͯΔϑΝΠϧͳͲΛੈք தʹedgeαʔόʔͰΩϟογϡ͠ ͓ͯಧ͚ Monday, September 3, 12

Slide 65

Slide 65 text

CloudFront ★(demo) ★(Ͳͬͪʹ͠ΖTokyoͳΜͰɺେ ͖ͳࠩ͸ग़·ͤΜ) Monday, September 3, 12

Slide 66

Slide 66 text

“Make fewer HTTP requests” ϦμΠϨΫτଟ͗͢ Monday, September 3, 12

Slide 67

Slide 67 text

ϦμΠϨΫτଟ͗͢ ★https://graph.facebook.com/4/ picture ★ => (302) CDNͷURL ★࣮ࡍͷը૾ΛϦΫΤετ Monday, September 3, 12

Slide 68

Slide 68 text

https://graph.facebook.com/4/picture ★(demo) Monday, September 3, 12

Slide 69

Slide 69 text

“Facebook”ͷͤ͘ʹإ ͷը૾औͬͯ͘Δͷ͕ ஗͍ͱ͸ͳʹ͝ͱͩ Monday, September 3, 12

Slide 70

Slide 70 text

ͦ͜Ͱɺը૾ϑΝΠϧΛࣗલͰ Ωϟογϡ ★ αʔόʔଆͰ͋Β͔͡Ίը૾Λμ΢ϯϩʔυ ★ S3ʹసૹ ★ CloudFront্ͷը૾URLΛϢʔβʔͷ identi erͱඥ෇͚ͯmemcachedʹΩϟογϡ ★ Ҏ্ͷॲཧΛCarrierWaveͷuploaderΛྲྀ༻͠ ࣮ͯ૷͸ίϯύΫτʹ Monday, September 3, 12

Slide 71

Slide 71 text

͜Μͳۤ࿑ͯ͠·ͰFB ࢖͏ඞཁ͋Μͷʁ Monday, September 3, 12

Slide 72

Slide 72 text

PROTIP: use Gravatar e.g. http://qa.atmarkit.co.jp/ users/a_matsuda Monday, September 3, 12

Slide 73

Slide 73 text

Cache-Control S3, CF্ͷը૾ϑΝΠϧͷΩϟο γϡؔ࿈ϔομ Monday, September 3, 12

Slide 74

Slide 74 text

CarrierWaveͳΒ؆୯ fog_attributesʹઃఆ͢Δ͚ͩ Monday, September 3, 12

Slide 75

Slide 75 text

ͦΜͳ͜ΜͳͰݱࡏͷ http://forkwell.com/ 2ඵલޙɺ͙Β͍ʁ Monday, September 3, 12

Slide 76

Slide 76 text

ࠓޙͷల๬ Monday, September 3, 12

Slide 77

Slide 77 text

Y current forkwell.com still slow? ★Assets ★social buttons & tracking ★શ෦ೖΓJS & શ෦ೖΓCSSͷฐ֐ ★ͦ΋ͦ΋τοϓϖʔδ͕ ͪ͝Όͪ͝Ό͗͢͠ Monday, September 3, 12

Slide 78

Slide 78 text

Assets ★·ͩPageSpeedʹౖΒΕΔ ★precompileͨ͠assets΋શ෦S3 & CFʹࡌͤΒΕͳ͍΋ͷ͔ʁ => asset_sync http://github.com/ rumblelabs/asset_sync Monday, September 3, 12

Slide 79

Slide 79 text

social buttons & tracking ★ඇಉظͰಡΈࠐΜͰ΋ͦͷޙ͕ ஗͍ ★Ͳ͏ʹ͔ͳΒΜ΋ͷ͔ Monday, September 3, 12

Slide 80

Slide 80 text

ࢼ͠ʹ͍ͭ͜Β͕ແ͔ͬͨΒʁ ★࣮͸LikeϘλϯͱTweetϘλϯͱ ΞΫηεղੳ͕ແ͔ͬͨΒ1ඵ୹ ॖ͞ΕΔ ★(demo) Monday, September 3, 12

Slide 81

Slide 81 text

શ෦ೖΓJS & શ෦ೖΓCSS ★Asset Pipelineͷ໋॓ ★τοϓϖʔδͰಡΈࠐΜͰΔCSS ͷ8ׂҎ্͸ؔ܎ͳ͍CSS ★΍ͬͺΓ࢖͏΋ͷ͚ͩʹ෼ׂ͠ ͨ΄͏͕଎ͦ͏ͳؾ͕ Monday, September 3, 12

Slide 82

Slide 82 text

ͦ΋ͦ΋τοϓϖʔδ͕ͪ͝Ό͝ ͪΌ͗͢͠ ★͜Ε͕࠷଎ http://qiita.com/ ★(ݸਓతʹ͸)͜Μͳײ͡ʹ͍ͨ͠ ★ʮϦσβΠϯʯ http:// forkwell.com/jobs/100 Monday, September 3, 12

Slide 83

Slide 83 text

ʮϦσβΠϯʯ ৽σβΠφʔ͞Μʹظ଴ʂ Monday, September 3, 12

Slide 84

Slide 84 text

end Monday, September 3, 12