Table, Sort, Edit and Add button all responding really slow on the server
Hello,
I am using FilamentPHP V3 and facing slowness issues on the server even with very simple table and a few records. It is comparatively fast on local server.
Please watch the video to see the response.
Please let me know how to diagnose what is causing the issue on the server.
The front-end is really working fast.
The server is shared hosting from namecheap.com and memory is 1GB only.
Thank you
14 Replies
There are other resources on this panel which are using relationship data and they are even more slow. None of my tables have more than 200 records.
First, check the network tab in your browser to see which request takes long and maybe even why. Might be any number of reasons. Just slow server (other requests taking as long?), database. Best case, use an analyzer solution to inspect what happens in the code and where it takes longer than expected
Hello @josef , the server is not slow because the front-end is pretty fast with complex queries as well. I will check the network tab and let you know how it looks.
This is when I just clicked on the sort title on table header, the content download and waiting for server response is quite high
this is on front-end getting data from 4 models
If this is not a prod environment, you could use the server timing api mentioned in your screenshots or the debug toolbar to further inspect what is taking so long
it is in prod environment, the local is working fast anyway.
I saw one difference here, the content-length is like 80000 or more
the response headers content-length on local is not displayed for the same table but on server it says content-length
I'm thinking you just have to bite the bullet and investigate server side what's taking long. Might be db queries, some misconfiguration, any number of reasons
ok thanks, I am confused because this is just a table with only 5 rows in the db, it should be fast
if the server was slow the front end would have been slower as well. I am running the other projects on exactly same server config without filamentphp admin panel and only using laravel livewire and it works smooth
anyway thanks for your time, I hope I can find something from server side and fix it.
same issue for me. I need to wait for 2 or more seconds then creation modal will show.
I found it also shows in official-demo: https://demo.filamentphp.com/blog/categories ,you can try the New Category button.
@mohdaftab Hi, I found a solution that u should install php-ext-opcache.
@celaraze thank you so much.
opcache is installed already
Hi @mohdaftab
Did this fix your issue?
Hello, I couldn't solve this issue with the live as there are so many relationship data to be loaded, we are just using it as it is for now