Order by before where (ARCH7076)

Key php.performance.orderby-before-where · Severity warning · Category performance

Sorting before filtering wastes work by ordering rows that are later discarded. Filter first, then sort the smaller result.

Incorrect

<?php
$result = collect($orders)
    ->sortBy('total')
    ->filter(fn ($o) => $o->status === 'paid')
    ->values();

Correct

<?php
$result = collect($orders)
    ->filter(fn ($o) => $o->status === 'paid')
    ->sortBy('total')
    ->values();

Fix

Move the sort after the filter step so only the smaller, needed set is ordered.