Slow pages ... due to too many load of data...
Hi Community, In a platform I am currently developing, some pages are slow. Too many load of data...
I am wondering if there is a config option that permit to have in the log the files/component/lines that call the ash.load or Ash.get... which do the SQL access to the DB ? In order to analyze the issue quicker ?
5 Replies
Not currently, no.
You can investigate the slow-logs for your particular DB though 🙂
Probably you can optimize some indexes or similar.
Slow-log +
EXPLAIN variant for your DB and you will most likly figure it out 🙂Yes I will figure it out... I have done that in the past... I was just trying to find an efficient faster way to do it...it is just that having kind of a "dbg" every time a Ash is requested... would be nice... because then I can quickly find where each call is done..
We've talked about having a debug mode for ash itself that would log all actions etc
You could do that, add temporarily to all your resources a preparation that debug logs that it's running a query
OK, I will try 🙂