Improve search performance - Filament

Filament•3y ago•

29 replies

Vincent Klaiber

Improve search performance

How can I optimize search performance for multiple columns in Filament when dealing with a table containing over 700,000 records?

return $table
    ->columns([
        Tables\Columns\TextColumn::make('id')
            ->label('ID')
            ->searchable(),
        Tables\Columns\TextColumn::make('name')->searchable([
            'first_name',
            'last_name',
        ]),
        Tables\Columns\TextColumn::make('email')->searchable(),
    ]);

return $table
    ->columns([
        Tables\Columns\TextColumn::make('id')
            ->label('ID')
            ->searchable(),
        Tables\Columns\TextColumn::make('name')->searchable([
            'first_name',
            'last_name',
        ]),
        Tables\Columns\TextColumn::make('email')->searchable(),
    ]);