Improve DB query time by 99% | DB query optimisation | Concepts based video | Laravel | 500k records

Описание: Hi all,

In this video, we will see how we can improve the query where we have to query the dataset of 500k records. I have tried to focus on the concepts and use the Laravel framework as a medium to use those concepts. Laravel provides out-of-the-box support for eager loading, caching and pagination. Similar concepts can be applied to most frameworks like Express, Fast API etc.

00:00 - Introduction
00:35 - DB problem we want to solve
01:27 - Problem with lazy loading and not using pagination
03:52 - Pagination
04:45 - Paginate and eager load
06:55 - Counting using SQL query and eager load (withCount)
10:17 - Paginate + eager load + Cache
14:20 - Outro


Follow me on Twitter:
  / adir1521  

Follow me on LinkedIn
  / adityakadam2194  

Follow me on GitHub
https://github.com/adityar15

Website
https://adiranids.com

Join this channel to get access to perks and exclusive videos:
   / @learnwithadiofficial