N+1 Query

[shineirvin]

public function fields(Request $request) {
        # this causing N+1 Query
        $items = Item::all()->pluck('name', 'id');

        return [
            Select2::make('Items', 'itemList')
                ->sortable()
                ->disableGoogleAnalytics(),                    
        ];
}

How do I prevent the N+1 Query issue ?

[koss-shtukert]

Hi @shineirvin, unfortunately, I don't know how to do that :( Maybe you can use a static list of items...

[angauber]

You could use some cache :

$items = Cache::rememberForever('MY_CACHE_KEY', function () {
    return Item::all()->pluck('name', 'id');
});

return [
    Select2::make('Items', 'itemList')
        ->options($items),
];

Don't forget to forget your Cache on create, delete or update of your item model

[ghost]

@shineirvin can U describe problem?