tracking the cause of a slow api call

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jamie
    Senior Member
    • Aug 2025
    • 103

    #1

    tracking the cause of a slow api call

    Does anyone have experience or advice on how to track what causes an api call to go ultra slow?
  • jamie
    Senior Member
    • Aug 2025
    • 103

    #2
    never mind i tracked it down with mysql slow functionality

    Comment

    • emillod
      Active Community Member
      • Apr 2017
      • 1497

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

      Comment

      • jamie
        Senior Member
        • Aug 2025
        • 103

        #4
        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

        Comment

        • emillod
          Active Community Member
          • Apr 2017
          • 1497

          #5
          Thank you man! Hope it'll help somebody

          Comment

          Working...