Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

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.

BIX performance benchmark

Updated on April 5, 2022

The following performance metrics were captured by running the BIX from a Windows Server command line against a series of Process Commander extract rules (Rule-Admin-Extract) of varying complexities.

Test setup and benchmark results

Four different extract rules were used. The Simple extract rule has twelve properties of mixed types (Text, Decimal, Double, Date, DateTime, and others).

Complex Level 1 extract rules have the same properties as Simple with the addition of the Page List and Page Group properties. Each embedded page has twelve properties.

Complex Level 2 has the same layout as Complex Level 1 plus one additional layer of Page Lists and Page Groups.

Complex Level 4 has the same layout as Complex Level 2 plus two layers of Page Lists and Page Groups.

Each extract rule was executed three times, each with 100000, 200000, 300000, 400000 and 500000 records (work objects). The chart below presents a summary of the extract rules.

Data structure

NamePropertyPagePage listPage groupLevel 1 embedded pageLevel 2 embedded pageLevel 3 embedded pageLevel 4 embedded page
SimpleXXXXXXXX
Complex level 1XXXXXXXX
Complex level 2XXXXXXXX
Complex level 4XXXXXXXX

Data structure

CPUIntel Xeon 2.5GHZ
Memory15 GB RAM
Hard Drive Disk (HDD)1.6 TB

System software

Operating SystemMicrosoft Windows Server 2003 Service Pack 2 (Enterprise Edition)
DatabaseOracle 10g
ANT VersionApache-ant 1.7.1
JREJRE 1.6.0_07

Benchmark results

The following graph shows the performance of a Comma Separated Values (CSV) extract for each set of records. For example, 500,000 Complex Level 4 records were extracted into a CVS file in 4 hours and 48 minutes, or about 29 records per second.

The following graph shows the performance of an XML extract for each set of records. For example, 500,000 Complex Level 4 records were extracted into an XML file in 3 hours, or about 46 records per second.

The following graph shows the performance of a Database schema extract for each set of records. For example, 500,000 Complex Level 4 records were extracted into a database schema file in 5 hours, or about 28 records per second.

The following graph shows the comparison between each type of extract for a Complex Level 4 data structure.

The following graph shows the amount of memory that was used during the extract.

Note: For Pega Cloud applications, BIX is an add-on service that Pega configures if you choose it as part of your subscription. For on-premises applications, BIX is available when you purchase and install the BIX application.

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us