Topics

Filament•6mo ago

David | Fortune Validator

Slow TextColumn with relationship exists

I am using the below code on my Client table:

Tables\Columns\IconColumn::make('estimates_exists')->exists('estimates')->boolean(),

Tables\Columns\IconColumn::make('estimates_exists')->exists('estimates')->boolean(),

This is the relationship:

public function estimates()
    {
        return $this->hasMany(Estimate::class);
    }

public function estimates()
    {
        return $this->hasMany(Estimate::class);
    }

It could have thousands of estimates. I simple need a boolean tick on my Table List to show if a client has an estimate against their name. The issue is its very very slow to load the page. If I comment out this line then its fast again. I dont suppose any knows of a better way to speed this up?

Solution:

problem solved. I didnt have index's setup in the database.

Jump to solution

1 Reply

Solution

David | Fortune Validator•6mo ago

problem solved. I didnt have index's setup in the database.

Filament is a collection of beautiful full-stack components for Laravel.You can get help using it on our Discord.

15KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

When navigating fast on the navbar, sometimes JS breaksThe error `Too many calls to Location or History APIs within a short timeframe.` It causes the pag How to retrieve current logged in user in AdminPanelProvider? 🤔i need to know which user is logged in to show a badge or hide it in a plugin of the filament admin Register custom resource pages on the side navigationHey - having trouble trying register a resource custom page in the side menu navigation This is ach The images do not loadI am using spatie media library Use metronic or any other admin panel with filament ?Hi all, I'm getting into filament to replace a few zend framework custom apps i have that are using Refresh TableWidget data after ActionI have a TableWidget in a View that queries certain data related to the information in the view. Ea Tailwind classes not found outside of filamentI'm using Filament for the first time and it is working beautifully, however I'm unable to use regul Broadcast Pusher NotificationsHi, I need to implement pusher notification on filament, and I have this: config/app.php ```php Ap