tracking the cause of a slow api call

[jamie]

Does anyone have experience or advice on how to track what causes an api call to go ultra slow?

[jamie]

never mind i tracked it down with mysql slow functionality

[emillod]

You can share details, maybe somebody will have similar issue in the future

[jamie]

i enabled MySQL slow tracking and then used the SQL command EXPLAIN on the slow query and found that one left join had 12000 records, we didn't need that join, so i just removed it

[emillod]

Thank you man! Hope it'll help somebody