Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

XML BIX Extracts running longer than DB Extract

SA-22838

Summary



After converting DataBase Business Intelligence Exchange (BIX) Extracts to XML BIX Extracts, performance is degraded with PRPC 6.2 SP1.


Error Messages



Not Applicable.


Steps to Reproduce



No steps to reproduce, volume and objects extracted are similar.


Root Cause



A defect or configuration issue in the operating environment.  

The issue is not related to the target output format. While the number of work objects being extracted has not increased the size of the work tables being extracted from and also the pr_log table has increased and as a result the query performance has decreased.

Resolution



In general the queries must be examined and corresponding tables must be partitioned and indexed.  

There is one query of the pr_log table, that could be improved greatly by a slight alteration to how it is written.  

An enhancement request, FDBK-15124, has been created for consideration by Pega Product Management. 

 

 

Suggest Edit

Published May 4, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us