Laravel Live Vietnam 2022: Laravel Eloquent Performance

Transcript

1. Laravel Vietnam Laravel Eloquent Performance "You can improve your Laravel app faster!"
2. 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
3. Laravel Vietnam TL;DR This is a long talk 😅
4. Laravel Vietnam What is Eloquent?
5. Laravel Vietnam
6. Laravel Vietnam Laravel Eloquent is Model Eloquent is an object relational mapper (ORM) that is included by default within the Laravel framework.
7. Laravel Vietnam Notice! This talk is not re-explain database, migrations, and models.
8. Laravel Vietnam Let's start with recommended tool.
9. Laravel Vietnam Laravel Debugbar By Barry vd. Heuvel
10. Laravel Vietnam https://github.com/barryvdh/laravel-debugbar
11. Laravel Vietnam
12. Laravel Vietnam No. 1 Indexing your necessary columns
13. Laravel Vietnam Seeding 10,000 users.
14. Laravel Vietnam
15. Laravel Vietnam
16. Laravel Vietnam
17. Laravel Vietnam
18. Laravel Vietnam
19. Laravel Vietnam
20. Laravel Vietnam No.2 Lazy Loading & Issue N+1
21. Laravel Vietnam
22. Laravel Vietnam
23. Laravel Vietnam Seeding 100 posts
24. Laravel Vietnam
25. Laravel Vietnam
26. Laravel Vietnam
27. Laravel Vietnam
28. Laravel Vietnam
29. Laravel Vietnam
30. Laravel Vietnam
31. Laravel Vietnam load () & loadMissing()
32. Laravel Vietnam load() & loadMissing() only call on Model or Eloquent Collection.
33. Laravel Vietnam How to prevent lazy loading?
34. Laravel Vietnam
35. Laravel Vietnam
36. Laravel Vietnam No. 3 Prefer using sub-query for dynamic property
37. Laravel Vietnam Requirement Add the `Last Published At` to the Users table.
38. Laravel Vietnam
39. Laravel Vietnam
40. Laravel Vietnam
41. Laravel Vietnam
42. Laravel Vietnam
43. Laravel Vietnam
44. Laravel Vietnam
45. Laravel Vietnam Requirement Sorting with `last_published_at` column?
46. Laravel Vietnam
47. Laravel Vietnam No. 4 Using "raw" to decrease query statements
48. Laravel Vietnam Requirement Show 3 blocks: 1. Total posts 2. Total published posts 3. Total draft posts
49. Laravel Vietnam
50. Laravel Vietnam
51. Laravel Vietnam Requirement Order by "published post -> drafted post" with "created_at" 😅
52. Laravel Vietnam
53. Laravel Vietnam No. 5 Using "setRelation" to decrease duplicated query statements
54. 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.
55. Laravel Vietnam
56. Laravel Vietnam
57. Laravel Vietnam
58. Laravel Vietnam Duplicated SQL Statements • The post detail • The post in the comment eager loader 👉 It took 2 statements but is the same.
59. Laravel Vietnam Introduce 👀 Model::setRelate()
60. Laravel Vietnam
61. Laravel Vietnam Bonus
62. Laravel Vietnam Eloquent Scope
63. Laravel Vietnam
64. Laravel Vietnam Eloquent Custom Query Builder
65. 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.
66. Laravel Vietnam
67. Laravel Vietnam Eloquent Accessor/Mutator
68. Laravel Vietnam The old ways: "getFieldNameAttribute" "setFieldNameAttribute" Both do not mention in the new version 😅
69. Laravel Vietnam
70. Laravel Vietnam
71. Laravel Vietnam
72. Laravel Vietnam Interacts with attributes
73. Laravel Vietnam
74. Laravel Vietnam Illuminate\Database\Eloquent\Concerns\HasAttributes
75. Laravel Vietnam Eloquent Guard Fields
76. Laravel Vietnam
77. Laravel Vietnam Do not do it! Security Issue!
78. Laravel Vietnam Illuminate\Database\Eloquent\Concerns\GuardsAttributes
79. Laravel Vietnam Relation property is difference relation method 😅
80. Laravel Vietnam
81. Laravel Vietnam Eloquent Custom Collection
82. 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.
83. Laravel Vietnam
84. Laravel Vietnam
85. Laravel Vietnam How to add new relation without edit the model 😎
86. Laravel Vietnam
87. Laravel Vietnam Lots of interesting things… I can't talk all of them 😅
88. Laravel Vietnam View Eloquent ORM In: laravel.com/docs
89. Laravel Vietnam Thank You Q&A