A recap about improving performance in PHP!

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

No content

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

No content

Slide 8

Slide 8 text

DETECTING THE PROBLEM

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

No content

Slide 11

Slide 11 text

No content

Slide 12

Slide 12 text

No content

Slide 13

Slide 13 text

No content

Slide 14

Slide 14 text

No content

Slide 15

Slide 15 text

No content

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

TOOLSET

Slide 19

Slide 19 text

No content

Slide 20

Slide 20 text

No content

Slide 21

Slide 21 text

No content

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

No content

Slide 24

Slide 24 text

No content

Slide 25

Slide 25 text

THE PERFORMANCE LOOP

Slide 26

Slide 26 text

BENCHMARK PROFILE MAKE CODE CHANGES

Slide 27

Slide 27 text

OPTIMIZING PHP

Slide 28

Slide 28 text

Zend Engine PHPNG

Slide 29

Slide 29 text

No content

Slide 30

Slide 30 text

Zend Engine PHPNG Allocates zval in HEAP memory Allocates zval on VM STACK memory

Slide 31

Slide 31 text

Zend Engine PHPNG Allocates zval in HEAP memory Allocates zval on VM STACK memory Pointers to existing zvals Creates new immutable zvals

Slide 32

Slide 32 text

Zend Engine PHPNG Allocates zval in HEAP memory Allocates zval on VM STACK memory Pointers to existing zvals Creates new immutable zvals Lot's of reference counting Avoids reference counting

Slide 33

Slide 33 text

Zend Engine PHPNG Allocates zval in HEAP memory Allocates zval on VM STACK memory Pointers to existing zvals Creates new immutable zvals Lot's of reference counting Avoids reference counting Lot's of garbage collection Avoids garbage collection on primitive values

Slide 34

Slide 34 text

Slide 35

Slide 35 text

Slide 36

Slide 36 text

Slide 37

Slide 37 text

No content

Slide 38

Slide 38 text

No content

Slide 39

Slide 39 text

No content

Slide 40

Slide 40 text

THE COST OF IO

Slide 41

Slide 41 text

THE FILESYSTEM IS SLOW

Slide 42

Slide 42 text

$ composer install -‐-‐optimize-‐autoloader

Slide 43

Slide 43 text

realpath_cache_size realpath_cache_ttl

Slide 44

Slide 44 text

CACHE YOUR FRAMEWORK CLASSES

Slide 45

Slide 45 text

$ composer require evandotpro/edp-‐superluminal

Slide 46

Slide 46 text

CACHE YOUR SERVICE CONFIGURATION

Slide 47

Slide 47 text

DON’T LOG TO THE FILESYSTEM

Slide 48

Slide 48 text

OPTIMIZING TEMPLATES

Slide 49

Slide 49 text

CACHE YOUR TEMPLATES

Slide 50

Slide 50 text

USE TEMPLATE MAP

Slide 51

Slide 51 text

EXPLICITLY SET VIEW PATH IN CONTROLLER

Slide 52

Slide 52 text

OPTIMIZING SERVICES

Slide 53

Slide 53 text

AVOID LOGIC IN THE CONSTRUCTOR

Slide 54

Slide 54 text

LIMIT THE NUMBER OF GLOBAL EVENT LISTENERS

Slide 55

Slide 55 text

USE LAZY SERVICES

Slide 56

Slide 56 text

SEND HEAVY WORK TO THE BACKGROUND

Slide 57

Slide 57 text

Caching

Slide 58

Slide 58 text

No content

Slide 59

Slide 59 text

ENABLE OPCACHE

Slide 60

Slide 60 text

WRITE CACHE TO CACHE SERVERS

Slide 61

Slide 61 text

USE FULL PAGE CACHING WHERE POSSIBLE

Slide 62

Slide 62 text

CONFIGURE BROWSER CACHE FOR STATIC FILES

Slide 63

Slide 63 text

CACHE FREQUENTLY USED DATA

Slide 64

Slide 64 text

CACHE DATA FROM INTEGRATIONS

Slide 65

Slide 65 text

ALSO CACHE SERIALIZED REPRESENTATIONS OF AN OBJECT

Slide 66

Slide 66 text

CACHE ANNOTATIONS

Slide 67

Slide 67 text

MICRO IMPROVEMENTS

Slide 68

Slide 68 text

KNOW YOUR ROUTER

Slide 69

Slide 69 text

DON’T USE DYNAMIC ASSET MANAGERS

Slide 70

Slide 70 text

CREATE STANDARD FILES

Slide 71

Slide 71 text

OPTIMIZING DOCTRINE

Slide 72

Slide 72 text

AVOID PROXIES IN OVERVIEWS

Slide 73

Slide 73 text

{% for employee in employees %} {{ employee.name }} {{ employee.company.name }} {% endfor %}

Slide 74

Slide 74 text

AVOID BI-‐DIRECTIONAL RELATIONS

Slide 75

Slide 75 text

USE DTO's WITH THE DATA YOU REALLY NEED

Slide 76

Slide 76 text

SELECT NEW CustomerDTO(c.name, e.email, a.city) FROM Customer c JOIN c.email e JOIN c.address a

Slide 77

Slide 77 text

DON’T CHANGE DATA IN DOCTRINE EVENT LISTENERS

Slide 78

Slide 78 text

AVOID DQL AND THE ORM FOR COMPLEX QUERIES

Slide 79

Slide 79 text

USE METADATA CACHE

Slide 80

Slide 80 text

USE QUERY CACHE

Slide 81

Slide 81 text

USE RESULT CACHE

Slide 82

Slide 82 text

ENABLE 2-‐LEVEL CACHE FOR STATIC DATASETS

Slide 83

Slide 83 text

FLUSH ENTITIES IN BATCH

Slide 84

Slide 84 text

CLEAR() THE ENTITY MANAGER AFTER TRANSACTION

Slide 85

Slide 85 text

OPTIMIZING MySQL

Slide 86

Slide 86 text

AVOID BLOB / TEXT TYPES

Slide 87

Slide 87 text

OPTIMIZE COLUMN SIZE BY IMPROVING DATA TYPES / LENGTH

Slide 88

Slide 88 text

USE UUID INSTEAD OF INCREMENTAL IDs

Slide 89

Slide 89 text

ONLY SELECT THE DATA YOU NEED

Slide 90

Slide 90 text

ALWAYS QUERY THROUGH INDEXES AND JOINS

Slide 91

Slide 91 text

AVOID HEAVY SUBQUERIES

Slide 92

Slide 92 text

EXPLAIN | DESCRIBE

Slide 93

Slide 93 text

No content

Slide 94

Slide 94 text

ENABLE SLOW QUERY LOGGING DURING DEVELOPMENT

Slide 95

Slide 95 text

USE A BIG INNODB BUFFER POOL SIZE

Slide 96

Slide 96 text

SKIP DOMAIN NAME RESOLVING AND CONNECT ON IP

Slide 97

Slide 97 text

KEEP PRIVILEGES TABLE SIMPLE

Slide 98

Slide 98 text

ACTIVATE QUERY CACHE

Slide 99

Slide 99 text

No content