Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Eloquent Performance Patterns, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:04:43
    Measuring your database performance
  2. Урок 2. 00:04:29
    Minimizing memory usage by selecting only
  3. Урок 3. 00:09:44
    Getting one record from has-many relationships
  4. Урок 4. 00:06:10
    Creating dynamic relationships using sub queries
  5. Урок 5. 00:04:21
    Calculating totals using conditional aggregates
  6. Урок 6. 00:04:25
    Optimizing circular relationships
  7. Урок 7. 00:04:07
    Setting up multi-column searching
  8. Урок 8. 00:05:05
    Getting LIKE to use an index
  9. Урок 9. 00:03:55
    Faster options than whereHas
  10. Урок 10. 00:03:08
    When it makes sense to run additional queries
  11. Урок 11. 00:07:58
    Using UNIONs to run queries independently
  12. Урок 12. 00:04:45
    Fuzzier searching using regular expressions
  13. Урок 13. 00:06:04
    Running authorization policies in the database
  14. Урок 14. 00:04:05
    Faster ordering using compound indexes
  15. Урок 15. 00:01:38
    Ordering by has-one relationships
  16. Урок 16. 00:01:39
    Ordering by belongs-to relationships
  17. Урок 17. 00:04:21
    Ordering by has-many relationships
  18. Урок 18. 00:05:39
    Ordering by belongs-to-many relationships
  19. Урок 19. 00:07:36
    Ordering with NULLs always last
  20. Урок 20. 00:06:38
    Ordering by custom algorithms
  21. Урок 21. 00:07:04
    Filtering and sorting anniversary dates
  22. Урок 22. 00:03:24
    Making N+1 issues impossible
  23. Урок 23. 00:04:20
    Ordering data for humans using natural sort
  24. Урок 24. 00:05:07
    Full text searching with rankings
  25. Урок 25. 00:03:23
    Getting the distance between geographic points
  26. Урок 26. 00:03:00
    Filtering by geographic distance
  27. Урок 27. 00:01:26
    Ordering by geographic distance
  28. Урок 28. 00:04:36
    Filtering by geospatial area