Posted: 13 Feb 2019 23:51 EST Last activity: 3 Jul 2019 0:11 EDT
WITH UR for Deadlock
We are upgrading an application from 7.1.5 to 7.4. We have few list views where the getContent has been customized to use WITH UR in the query. We came to know there were few deadlock scenarios earlier in tables for which DBA suggested to use WITH UR in queries.
As in 7.4, we are planning to move to RD, we won't be able to use this WITH UR in RD. As Pega also uses RD wherever possible, just want to check do they take care of this deadlock scenarios by themselves in RD if such scenarios occur in application?
***Edited by Moderator: Pallavi to update platform capability tags***
There was a huge enhancement changes with the product 7.1.5 to 7.4 on all the modules and in RD too and we have to try with the 7.4, It should work without any deadlock as there are many improvement areas implemented, Suggesting you to use the Pega recommended DB drivers which best suits for your PRPC 7.4.