Skip to main content
Question

Quick report timing out

  • October 2, 2024
  • 1 reply
  • 55 views
A
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Ash1807
  • Do Gooder (Customer)
  • 3 replies

Have a QR with several API calls. This is constantly timing out, though I am able to see all the rows on the DB through PL/SQL

 

Will the  TCP Idle Timeout value in the load balancer make a significant difference to the execution of the QR?

 

 

    1 reply

    NiyomalN
    Hero (Partner)
    Forum|alt.badge.img+11
    • NiyomalN
    • Hero (Partner)
    • 104 replies
    • October 2, 2024

    Have a QR with several API calls. This is constantly timing out, though I am able to see all the rows on the DB through PL/SQL

     

    Will the  TCP Idle Timeout value in the load balancer make a significant difference to the execution of the QR?

     

     

    @Ash1807 try adding some indexes in your quick report and see whether it makes any difference.  ex./*+INDEX(table_name column_having_index)*/ 

    kind Regards!

    Niyomal

    LinkedIn : www.linkedin.com/in/ niyomal-nathanielsz-18112341


    Terms & ConditionsCookie settingsAccessibility statement