Confoo 2016 - Make it Faster

make it faster Guillaume Malette gmalette ! "

https://github.com/gmalette/Confoo2016/

we need to talk

phpbench.com

#perfmatters http://www4.akamai.com/html/about/press/releases/2009/press_091409.html https://blog.kissmetrics.com/loading-time/

slow is what? https://www.nngroup.com/articles/response-times-3-important-limits/

why is my site slow?

php php php php laravel php php php ruby rails
API sql redis memcached etc

benchmark identify change

benchmark

reusable high confidence

client nginx application action query

// https://github.com/gmalette/Confoo2016 public function handle($request, Closure $next) { \Log::info( sprintf(
"\n\n[Request] Started to %s routed to %s", $request->path(), $request->route()->getAction()['controller'] ) ); $before = microtime(true); $response = $next($request); $after = microtime(true); \Log::info( sprintf( "[Request] Responded %d in %dms", $response->status(), ($after - $before) * 1000 ) ); return $response; }

[Request] Started to / routed to \PostsController@getIndex ... [Request] Responded
200 in 330ms

identify

New Relic Datadog

change

benchmark

questions?

database

orm logs

[SQL] select * from ùsers` where ùsers`.ìd` = 7842 limit
1 (0.63 ms) [SQL] select * from `tags` where `tags`.`post_id` = 30 and `tags`.`post_id` is not null (0.6 ms)

n+1 queries

posts = Post.all posts.each do |post| puts post.author.email end

posts = Post.includes(:author).all posts.each do |post| puts post.author.email end

slow query logs

# Time: 2016-02-20T17:09:43.618399Z # User@Host: homestead[homestead] @ [172.16.225.2] Id: 2465
# Query_time: 1.151 Lock_time: 0.00013 Rows_sent: 50 Rows_examined: 500000 select * from `tags` where `tags`.`post_id` in ( '1', '2', '3', '4', '5', '6', '7', '8', '9', '10' );

# Time: 2016-02-20T17:09:43.618399Z # User@Host: homestead[homestead] @ [172.16.225.2] Id: 2465
# Query_time: 1.151 Lock_time: 0.00013 Rows_sent: 50 Rows_examined: 500000 select * from `tags` where `tags`.`post_id` in ( '1', '2', '3', '4', '5', '6', '7', '8', '9', '10' ); /*application:Shopify,controller:orders,request_id:bc12813bce*/ basecamp/marginalia

background

analytics emails uploads

preload

software profilers

flamegraph stackprof xhprof

wall cpu memory

��
��

questions?

thank you! Guillaume Malette gmalette ! "

Confoo 2016 - Make it Faster

Confoo 2016 - Make it Faster

More Decks by Guillaume Malette

Other Decks in Programming

Featured

Transcript