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/filamentphp/demo
- SQL dump of the database shown in the video: drive.google.com/file/d/1P284...
- Filament issue I've opened: github.com/filamentphp/filame...
- My Eloquent courses: laraveldaily.com/courses
- More Filament examples on our website: filamentexamples.com

Пікірлер: 29

  • @hussain4real
    @hussain4real5 күн бұрын

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

  • @spadedaman4958

    @spadedaman4958

    5 күн бұрын

    yeah, same.

  • @FindWebX
    @FindWebX5 күн бұрын

    Thank you

  • @vitaliejalbu8206
    @vitaliejalbu82065 күн бұрын

    here is, thak you bery much

  • @kreaweb-be
    @kreaweb-be5 күн бұрын

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

  • @renatofrota
    @renatofrota5 күн бұрын

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

  • @FilamentDaily

    @FilamentDaily

    5 күн бұрын

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

  • @khafi22
    @khafi225 күн бұрын

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

  • @FilamentDaily

    @FilamentDaily

    5 күн бұрын

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

  • @darkbelg
    @darkbelg5 күн бұрын

    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

    @FilamentDaily

    5 күн бұрын

    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?

  • @phoenixedge4049
    @phoenixedge40494 күн бұрын

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

  • @FilamentDaily

    @FilamentDaily

    4 күн бұрын

    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

  • @ellmatic
    @ellmatic5 күн бұрын

    RELAUNCH TO UPDATE

  • @hshxy
    @hshxy5 күн бұрын

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

  • @FilamentDaily

    @FilamentDaily

    5 күн бұрын

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

  • @hshxy

    @hshxy

    5 күн бұрын

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

  • @hshxy

    @hshxy

    5 күн бұрын

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

  • @FilamentDaily

    @FilamentDaily

    5 күн бұрын

    Yeah, email me povilas@laraveldaily.com

  • @mori181186
    @mori1811866 күн бұрын

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

  • @tahinuralam

    @tahinuralam

    6 күн бұрын

    Yes unauthenticated Page with infolist layout that means a landing page

  • @krekas

    @krekas

    6 күн бұрын

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

  • @tahinuralam

    @tahinuralam

    6 күн бұрын

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

  • @FilamentDaily

    @FilamentDaily

    5 күн бұрын

    @mori I already have a video about Filament forms on the front-end: kzread.info/dash/bejne/g452uqlxf7bgZ7g.html

  • @FilamentDaily

    @FilamentDaily

    5 күн бұрын

    @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.