Discussion on: Laravel: Performance Boost!

View post

Replies for: This request $request->user()->incomes()->get(); produce something like that: SELECT * FROM users WHERE id = 2 SELECT * FROM incomes WHER...

@simpledevme you are correct! The following Eloquent query has the same improved performance. I'll edit the article this evening. Thank you for that information!

return Income::selectRaw("substr(date_income_received, 1, 4) as year")
            ->whereUserId($request->user()->id)
            ->groupBy('year')
            ->pluck('year');