Qu Posts - Answer Overflow

•Created by Qu on 11/13/2023 in #❓┊help

Searching in big database results in timeout

Hello, when searching in my table I keep running into timeouts. The exact error is "Maximum execution time of 60 seconds exceeded" at the return statement of the Database\Connection.php The database has a field uuid which contains an uuid. When I write a manual select statement it takes about 0.8s to get the results. I also tried in another Laravel project and the queries seem to execute quickly. This is the code for the table function

    public static function table(Table $table): Table
    {
        return $table
            ->columns([
                Tables\Columns\TextColumn::make('time')
                    ->dateTime("d.m.Y - H:m:s")
                    ->sortable(),
                Tables\Columns\TextColumn::make('type')
                    ->numeric(),
                Tables\Columns\TextColumn::make('uuid')
                    ->label('UUID')
                    ->copyable()
                    ->searchable(isIndividual: true),
            ])
            ->actions([
            ])
            ->bulkActions([
            ])
            ->emptyStateActions([
            ])
            ->deferLoading();
    }

    public static function table(Table $table): Table
    {
        return $table
            ->columns([
                Tables\Columns\TextColumn::make('time')
                    ->dateTime("d.m.Y - H:m:s")
                    ->sortable(),
                Tables\Columns\TextColumn::make('type')
                    ->numeric(),
                Tables\Columns\TextColumn::make('uuid')
                    ->label('UUID')
                    ->copyable()
                    ->searchable(isIndividual: true),
            ])
            ->actions([
            ])
            ->bulkActions([
            ])
            ->emptyStateActions([
            ])
            ->deferLoading();
    }

I also tried giving it a custom query analogue to what I did in the other laravel project (it really just is a where statement), producing this

                    ->searchable(query: function (Builder $query, string $search): Builder {
                        return $query->where('uuid', $search);
                    }, isIndividual: true),

                    ->searchable(query: function (Builder $query, string $search): Builder {
                        return $query->where('uuid', $search);
                    }, isIndividual: true),

Have I missed something where I could've changed something? (I am in my early php stages) What I just found out through some more testing is that the search works fine when I use a uuid that in the first couple of hundred (or thousand for that matter) rows, but using one that is "further away" seems to hang the search entirely. Thanks in advance for any pointers

18 replies

Gaming

Programming