Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Avinash Haridasu (Avinash.Haridasu) Morgan Stanley
Morgan Stanley
IN
Avinash.Haridasu Member since 2014 306 posts
Morgan Stanley
Posted: Mar 15, 2021
Last activity: Apr 12, 2021
Posted: 15 Mar 2021 10:16 EDT
Last activity: 12 Apr 2021 11:24 EDT
Closed

ABAC policy condition with One Of condition is running too slow in DB2

We have used ABAC policy conidtion with One of. The filtering criteria is working fine but the query has turned out to be too slow due to ABAC.

Using One Of internally is adding a function call to compare column values with that of CSV we passed in right side of condition in condition rule. Looks like the function is slowing down the query.

Without the function it takes a second but with function (ABAC enabled) it takes around 7 seconds.

***Edited by Moderator Marissa to update Platform Capability tags****
To see attachments, please log in.
Pega Platform 8.5.2 Performance

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice