Mack H Comments - Answer Overflow

The problem is I was using .tif as the example, but in reality it could be "blah". So wildcard is going to the be used the most. The reality is the actual query is fast, but the count is slow. The numbers bare that out. Thank you for the all the input.

19 replies

FFilament

•Created by Mack H on 8/21/2024 in #❓┊help

Count slow query

Aslo it's Postgres. If that matters to anyone.

19 replies

FFilament

•Created by Mack H on 8/21/2024 in #❓┊help

Count slow query

@Matthew yes I have indexes

-- Indices
CREATE INDEX idx_originals_dir ON public.originals USING btree (dir);
CREATE INDEX idx_originals_filename ON public.originals USING btree (filename);
CREATE INDEX idx_originals_callno ON public.originals USING btree (callno);

-- Indices
CREATE INDEX idx_originals_dir ON public.originals USING btree (dir);
CREATE INDEX idx_originals_filename ON public.originals USING btree (filename);
CREATE INDEX idx_originals_callno ON public.originals USING btree (callno);

@awcodes It's just the query I pulled out of ray with showQueries. It's just as slow if I run it in TablePlus. I don't know that I have any options, but I'm looking.

19 replies

FFilament

•Created by Mack H on 8/21/2024 in #❓┊help

Count slow query

19 replies

FFilament

•Created by Mack H on 12/12/2023 in #❓┊help

Delay searches

https://github.com/filamentphp/filament/blob/b31bc2de29819e6f385b6e27c5fa7b16762ecfd7/packages/tables/resources/views/components/search-field.blade.php#L25 Publish to resources/views/vendor/filament-tables/components/search-field.blade.php and in my case change line to

:wire:model.live.debounce.500ms="$wireModel"

:wire:model.live.debounce.500ms="$wireModel"

:wire:model.change="$wireModel"

:wire:model.change="$wireModel"

Our tables have so much data and such long names we need it to react when enter or tab is pressed.

7 replies

FFilament

•Created by Mack H on 12/12/2023 in #❓┊help

Delay searches

@DrByte yeah. I forgot to post the solution i came up with doing that now.

7 replies

FFilament

•Created by Mack H on 10/18/2023 in #❓┊help

RelationManager Page Url Paramater

Worked perfect.

11 replies

FFilament

•Created by Mack H on 10/18/2023 in #❓┊help

RelationManager Page Url Paramater

One of the things I love about FIlament is just how extendable it is, but FUCK me there is now way it's this easy. I'm trying this in the morning. I'm forever in your debt.

11 replies

FFilament

•Created by Mack H on 10/18/2023 in #❓┊help

RelationManager Page Url Paramater

Wow, thanks. I did my own digging with my limited knowledge and couldn’t source it. Looking at the wire PRs would have been smart.

11 replies

FFilament

•Created by Mack H on 10/18/2023 in #❓┊help

RelationManager Page Url Paramater