Skip to main content
Question

Quick report timing out

  • October 2, 2024
  • 1 reply
  • 40 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+10
    • NiyomalN
    • Hero (Partner)
    • 102 replies
    • October 2, 2024
    Ash1807 wrote:

    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

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings