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

Опубликовано: 12 Декабрь 2022
на канале: WebDevWithArtisan

273

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:
   / @webdevwithartisan

Смотрите видео Improve DB query time by 99% | DB query optimisation | Concepts based video | Laravel | 500k records онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь WebDevWithArtisan 12 Декабрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 27 раз и оно понравилось людям.

62,17

1.7 тыс