Qu
Qu
PostsComments
FFilament
Created by Qu on 11/13/2023 in #❓┊help
Searching in big database results in timeout
I changed it to sort by a timedate column since sorting by the id doesn't make sense in this case.
18 replies
FFilament
Created by Qu on 11/13/2023 in #❓┊help
Searching in big database results in timeout
The table does have an index 🤔
18 replies
FFilament
Created by Qu on 11/13/2023 in #❓┊help
Searching in big database results in timeout
Changing the default sort did the trick
18 replies
FFilament
Created by Qu on 11/13/2023 in #❓┊help
Searching in big database results in timeout
No I probably only need to figure out how to remove that from the query
18 replies
FFilament
Created by Qu on 11/13/2023 in #❓┊help
Searching in big database results in timeout
Ah I found the "issue" Selecting from the database is very quick, but not if you add order by xxx asc
18 replies
FFilament
Created by Qu on 11/13/2023 in #❓┊help
Searching in big database results in timeout
and if I do a direct SELECT * FROM xxx WHERE uuid="..." it also runs in under a second
18 replies
FFilament
Created by Qu on 11/13/2023 in #❓┊help
Searching in big database results in timeout
Yes, in my only laravel project the query with a $query->where('uuid', $uuid) runs in under a second
18 replies
FFilament
Created by Qu on 11/13/2023 in #❓┊help
Searching in big database results in timeout
The last query I see in debugging is just an aggregate query that does count(*) on the table with the filter I set, that query runs in 0.something ms I will try it w/o pagination later Currently I do not have any relationships configured but I will check The initial amount of rows is quite large but once you set the uuid filter it is down to like 170k rows
18 replies