BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
Back to discussions
Expand all | Collapse all

Maximum Number of Queries in Execute Multiple Operation of SQL Connector

  • 1.  Maximum Number of Queries in Execute Multiple Operation of SQL Connector

    Posted Sun November 21, 2021 08:32 AM
    I am using BAW 20.0.0.1 and wanted to understand that is there any limitation on the number of queries which can be used in ExceuteMultiple Operation or CallMultiple Operation of the SQL Connector.

    Requirement- I am inserting the instanceId retrieved from the TWsearch on date range filter in a temporary table and then retrieving business data related to the instance ids by joining this temporary table from other business data tables.
    Reason why I am fetching InstanceId from TwSearch is because i want to check the user authorization as well.
    I have tested this with approx 400 queries and it is working fine. However in production we might get upto 20k records so was curious to know about the max limit and the approach which I am using.

    ------------------------------
    Akash Gupta
    ------------------------------


  • 2.  RE: Maximum Number of Queries in Execute Multiple Operation of SQL Connector

    Posted Mon November 22, 2021 09:07 AM
    Given that there is a way to throttle twsearch results, I would suggest you not do the 20K at once.  Also, keep in mind that BAW has an optional configuration to stop the "runaway threads".  In addition if you are doing this from a UCA service, you may run into transaction time out.

    ------------------------------
    Mikhail Zilbergleyt
    ------------------------------

    Original Message