Laravel Live Vietnam 2022: Laravel Eloquent Performance

Slide 1

Slide 1 text

Laravel Vietnam Laravel Eloquent Performance "You can improve your Laravel app faster!"

Slide 2

Slide 2 text

Laravel Vietnam Who? ● My name is Dinh Quoc Han / Đinh Quốc Hân ● I'm a PHP Lover, Laravel fan! ● 7 years experience in software development ● Currently working at SHIFT ASIA ● Admin at Laravel Vietnam

Slide 3

Slide 3 text

Laravel Vietnam TL;DR This is a long talk 😅

Slide 4

Slide 4 text

Laravel Vietnam What is Eloquent?

Slide 5

Slide 5 text

Laravel Vietnam

Slide 6

Slide 6 text

Laravel Vietnam Laravel Eloquent is Model Eloquent is an object relational mapper (ORM) that is included by default within the Laravel framework.

Slide 7

Slide 7 text

Laravel Vietnam Notice! This talk is not re-explain database, migrations, and models.

Slide 8

Slide 8 text

Laravel Vietnam Let's start with recommended tool.

Slide 9

Slide 9 text

Laravel Vietnam Laravel Debugbar By Barry vd. Heuvel

Slide 10

Slide 10 text

Laravel Vietnam https://github.com/barryvdh/laravel-debugbar

Slide 11

Slide 11 text

Laravel Vietnam

Slide 12

Slide 12 text

Laravel Vietnam No. 1 Indexing your necessary columns

Slide 13

Slide 13 text

Laravel Vietnam Seeding 10,000 users.

Slide 14

Slide 14 text

Laravel Vietnam

Slide 15

Slide 15 text

Laravel Vietnam

Slide 16

Slide 16 text

Laravel Vietnam

Slide 17

Slide 17 text

Laravel Vietnam

Slide 18

Slide 18 text

Laravel Vietnam

Slide 19

Slide 19 text

Laravel Vietnam

Slide 20

Slide 20 text

Laravel Vietnam No.2 Lazy Loading & Issue N+1

Slide 21

Slide 21 text

Laravel Vietnam

Slide 22

Slide 22 text

Laravel Vietnam

Slide 23

Slide 23 text

Laravel Vietnam Seeding 100 posts

Slide 24

Slide 24 text

Laravel Vietnam

Slide 25

Slide 25 text

Laravel Vietnam

Slide 26

Slide 26 text

Laravel Vietnam

Slide 27

Slide 27 text

Laravel Vietnam

Slide 28

Slide 28 text

Laravel Vietnam

Slide 29

Slide 29 text

Laravel Vietnam

Slide 30

Slide 30 text

Laravel Vietnam

Slide 31

Slide 31 text

Laravel Vietnam load () & loadMissing()

Slide 32

Slide 32 text

Laravel Vietnam load() & loadMissing() only call on Model or Eloquent Collection.

Slide 33

Slide 33 text

Laravel Vietnam How to prevent lazy loading?

Slide 34

Slide 34 text

Laravel Vietnam

Slide 35

Slide 35 text

Laravel Vietnam

Slide 36

Slide 36 text

Laravel Vietnam No. 3 Prefer using sub-query for dynamic property

Slide 37

Slide 37 text

Laravel Vietnam Requirement Add the `Last Published At` to the Users table.

Slide 38

Slide 38 text

Laravel Vietnam

Slide 39

Slide 39 text

Laravel Vietnam

Slide 40

Slide 40 text

Laravel Vietnam

Slide 41

Slide 41 text

Laravel Vietnam

Slide 42

Slide 42 text

Laravel Vietnam

Slide 43

Slide 43 text

Laravel Vietnam

Slide 44

Slide 44 text

Laravel Vietnam

Slide 45

Slide 45 text

Laravel Vietnam Requirement Sorting with `last_published_at` column?

Slide 46

Slide 46 text

Laravel Vietnam

Slide 47

Slide 47 text

Laravel Vietnam No. 4 Using "raw" to decrease query statements

Slide 48

Slide 48 text

Laravel Vietnam Requirement Show 3 blocks: 1. Total posts 2. Total published posts 3. Total draft posts

Slide 49

Slide 49 text

Laravel Vietnam

Slide 50

Slide 50 text

Laravel Vietnam

Slide 51

Slide 51 text

Laravel Vietnam Requirement Order by "published post -> drafted post" with "created_at" 😅

Slide 52

Slide 52 text

Laravel Vietnam

Slide 53

Slide 53 text

Laravel Vietnam No. 5 Using "setRelation" to decrease duplicated query statements

Slide 54

Slide 54 text

Laravel Vietnam Example We have a comments list shown in the post. Comment::class has an accessor `url`, it will be the link of the comment (The post URL with comment fragment). So, it will be a duplicate query statement if shown on the post detail page. Let me show you.

Slide 55

Slide 55 text

Laravel Vietnam

Slide 56

Slide 56 text

Laravel Vietnam

Slide 57

Slide 57 text

Laravel Vietnam

Slide 58

Slide 58 text

Laravel Vietnam Duplicated SQL Statements ● The post detail ● The post in the comment eager loader 👉 It took 2 statements but is the same.

Slide 59

Slide 59 text

Laravel Vietnam Introduce 👀 Model::setRelate()

Slide 60

Slide 60 text

Laravel Vietnam

Slide 61

Slide 61 text

Laravel Vietnam Bonus

Slide 62

Slide 62 text

Laravel Vietnam Eloquent Scope

Slide 63

Slide 63 text

Laravel Vietnam

Slide 64

Slide 64 text

Laravel Vietnam Eloquent Custom Query Builder

Slide 65

Slide 65 text

Laravel Vietnam When? If you have a lot of scope methods in the model and you won't find a way to extract this into the new class. This is exactly the way you want.

Slide 66

Slide 66 text

Laravel Vietnam

Slide 67

Slide 67 text

Laravel Vietnam Eloquent Accessor/Mutator

Slide 68

Slide 68 text

Laravel Vietnam The old ways: "getFieldNameAttribute" "setFieldNameAttribute" Both do not mention in the new version 😅

Slide 69

Slide 69 text

Laravel Vietnam

Slide 70

Slide 70 text

Laravel Vietnam

Slide 71

Slide 71 text

Laravel Vietnam

Slide 72

Slide 72 text

Laravel Vietnam Interacts with attributes

Slide 73

Slide 73 text

Laravel Vietnam

Slide 74

Slide 74 text

Laravel Vietnam Illuminate\Database\Eloquent\Concerns\HasAttributes

Slide 75

Slide 75 text

Laravel Vietnam Eloquent Guard Fields

Slide 76

Slide 76 text

Laravel Vietnam

Slide 77

Slide 77 text

Laravel Vietnam Do not do it! Security Issue!

Slide 78

Slide 78 text

Laravel Vietnam Illuminate\Database\Eloquent\Concerns\GuardsAttributes

Slide 79

Slide 79 text

Laravel Vietnam Relation property is difference relation method 😅

Slide 80

Slide 80 text

Laravel Vietnam

Slide 81

Slide 81 text

Laravel Vietnam Eloquent Custom Collection

Slide 82

Slide 82 text

Laravel Vietnam When? If you have a lot of logic collection methods with the model. E.g: The positive price invoice lines. You don't need to rewrite logic in many places.