Filament Performance: 1M DB Rows - Benchmark

Let's test if Filament is slower with larger amount of data, and discuss the SQL queries under the hood.
Links mentioned in the video:
Official Filament Demo on GitHub: github.com/fil...
SQL dump of the database shown in the video: drive.google.c...
Filament issue I've opened: github.com/fil...
My Eloquent courses: laraveldaily.c...
More Filament examples on our website: filamentexampl...

[@hussain4real]

I tend to cache anything that has to do with count, either in widgets or navigation badge

[@spadedaman4958]

yeah, same.

[@OS-Advertising]

to be honest 2.5s for 1M rows is fine for me, i can deal with that

[@darkbelg]

I'm not convinced of the conclusion. Unless filament have done some performance optimalizations this is not what my experience is.
The demonstration of 10 items taking 800ms raises some questions about performance. I'm curious to know if this is within the expected range for this type of implementation. Would it be possible to explore the impact of increasing the number of records per page, say to 100, to better understand the performance impact?
I'm missing insights on possible livewire performance issues.
I also made a project in filament. According to debug bar it takes 703ms to load the page but database retrieval was only 10 ms. Where did the other ms go? This is with octane and 100 items per page.
As for the graphs if they are a separate ajax call. I don't see why you would remove them. They don't slow down the call to show the data, right?

[@FilamentDaily]

Good and valid questions. I guess there should be a separate video about the Livewire and front-end part of Filament and how it works. But should it be the same example?
Or can you give me access to that 800ms project so I would investigate?

[@khafi22]

Actually, part of filament slowness is due to livewire and nested views

[@FilamentDaily]

Yes but I'm yet to experience/reproduce it in my projects. Do you have any examples or screenshots or links?

[@kreaweb-be]

Helas, aggregate functions (SUM, AVG,...) can not be indexed on SQL.

[@vitaliejalbu8206]

here is, thak you bery much

[@FindWebX]

Thank you

[@renatofrota]

Did you try enabling SPA mode? The counters on sidebar would not run multiple times, I suppose.

[@FilamentDaily]

No I didn't, would be an interesting experiment.

[@mori181186]

Video Request: Add a Filament Form in the frontend, without loggedin user.

[@tahinuralam]

Yes unauthenticated Page with infolist layout that means a landing page

[@krekas]

form the form you can add it to a livewire component. for the infolist should be the same

[@tahinuralam]

@@krekas but how to add multiple table/widegt in infolist ?
Thanks in advance

[@FilamentDaily]

@mori I already have a video about Filament forms on the front-end: th-cam.com/video/QZBXG8OSz7U/w-d-xo.html

[@FilamentDaily]

@tahinuralam personally, I wouldn't build a LANDING page with Filament. It's not its core purpose. I would better use some Tailwind/Bootstrap theme.

[@phoenixedge4049]

Can you do a video on how best to cache some of these things?

[@FilamentDaily]

I wrote about it as a part of a premium tutorial from Laravel side on my LaravelDaily: laraveldaily.com/post/eloquent-performance-enum-int-tinyint-and-softdeletes

[@hshxy]

Video request: Grid view, where you can view recurring tasks with their deadline dates.

[@FilamentDaily]

Can you link to any screenshot how exactly it would look? I mean not in filament, in any other system.

[@hshxy]

@@FilamentDaily I just tried adding a link but seems like youtube deleted my comment automatically 😕

[@hshxy]

Do you have a contact like an email where I could send you this?

[@FilamentDaily]

Yeah, email me [e-mail]

[@ellmatic]

RELAUNCH TO UPDATE