We are running an Extract rule in an activity via agent to run the BIX daily. We are using pxExtractDataWithArgs activity. We are facing performance issue in BIX lately. By default in PEGA, number of records to update at a time is 30. We want to increase the performance. I have a question that by increasing the count it will improve the performance?? What will happen if we change it to 40 or 50???
We are getting query timeout error frequently. Our query timeout value in DSS is 60 seconds. This timeout value is for the select query in PEGA table or BIX table??? How to overcome this timeout issue?
What is the best practice to perform BIX extract to increase the performance?