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