Filament Performance Issue: Slow Response Time with SQL Server
I'm using Filament with SQL Server as my database. I'm experiencing intermittent performance issues where my project sometimes loads quickly, and other times it's extremely slow (see attached screenshot).
I've been searching for solutions for the past day, but I've only found temporary fixes like clearing the cache. Has anyone else encountered this issue? Are there any permanent solutions or ways to diagnose the root cause of this problem?
4 Replies
At times, it loads this quickly
have any leads?
The potential reasons for this are almost endless.
Start by removing the variables. If you are going across a network, then use a local environment, if you have a large dataset, then experiment with a cut down database.
Run the queries directly on the DB server using SMSS.
Ensure you have set up SQL Server properly, or hopefully, you've got a DBA to sort that,
SQL Server has lots of optimiser tools. Including slow query identification, and missing indexes. Read up on that. Also, bear in mind that SQL Server will be caching results, so a slow query can come back quickly on the second and third instance, and later on forget it, and back to a slow one.
Are you using multi tenancy?