XML BIX Extracts running longer than DB Extract
After converting DataBase Business Intelligence Exchange (BIX) Extracts to XML BIX Extracts, performance is degraded with PRPC 6.2 SP1.
Steps to Reproduce
No steps to reproduce, volume and objects extracted are similar.
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.
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.