Skip Headers

Agile Product Lifecycle Management Capacity Planning Guide Release 9.3.3 E39278-01 |
| Contents

Previous | Next |

# 3 Breakpoint Testing Results

This chapter includes scalability data and breakpoint testing results.

## 3.1 Reports Scalability Data

This section provides results for reports scalability data.

### 3.1.1 Heap Consumption in Reports

When calculating resource needs, assume that reports will consume one-third of application server resources (Heap and CPU). For example, if the application server heap size is set to 1280, then the available heap on that application server for reports should be estimated as 426MB (1280m/3 = 426m).

Note: Depending on the report, 1024 MB of available heap can typically handle up to 300K rows.

Total Heap Size (in megabytes) | Available Heap Size for Reports | Maximum rows based on available heap
--- | --- | ---
1024 | 341 | 100,000
1280 | 427 | 125,000
2048 | 683 | 200,000
3072 | 1024 | 300,000

### 3.1.2 Protecting the Application Server

Agile PLM now provides two configuration parameters to limit report result set sizes and avoid out-of-memory errors. The configuration parameters are:

- report.maxStandardBOMReportResults - set in the agile.properties file, this parameter sets the maximum number of BOM reports.

- MaxReportResults - set in the Java Client, this parameter sets the maximum number of all non-BOM reports.

### 3.1.3 Example: Configuration Scenario

Scenario: The environment has a clustered deployment with 4 managed servers each having heap size of 3072m (assumes 64-bit JDK).

Considering the above scenario, the following table provides suggestions for the value of the report configuration parameters, depending on the desired number of reports to be executed concurrently.

Total Heap Size | Maximum Result Set Per Node | Desired Concurrent Reports Per Node | Suggested Value For Above Parameters
3072m 3072m | 300K rows | 3 | 100K
3072m | 300K rows | 5 | 60K
3072m | 300K rows | 10 | 30K
3072m | 300K rows | 12 | 25K
3072m | 300K rows | 15 | 20K

## 3.2 Solution Results on Windows and Linux

The following tables show the results of breakpoint testing on the Product Collaboration, Product Quality Management, Product Portfolio Management, Product Cost Management, and Product Governance & Compliance solutions, and the Distributed File Manager and Export components. The testing was initially performed with Agile PLM running on Windows 2003 systems, but follow-up testing resulted in the same findings on Oracle Enterprise Linux 4 or RedHat Linux version 4

Note: The response times for all of the tables are measured in seconds and are for single user only.

### 3.2.1 Product Collaboration

The following are breakpoint testing results for the Product Collaboration solution.

#### 3.2.1.1 Change Object

The following table lists the results for Copy and Paste Affected Items.

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
500 | 40 | 10% | 10%
2000 | 240 | 25% | 10%
3000 | 570 | 25% | 10%
5000 | Timed out | 25% | 12%

The following table lists the results for Save As Change.

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 17 | 10% | 5%
2500 | 57 | 15-25% | 5%
5000 | 153 | 25% | 5%
7500 | 268 | 25% | 5%
10000 | 450 | 25% | 5%

The following table lists the results for Change Status to Release (with Preliminary Items).

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 27 | 5% | 10%
2500 | 70 | 5% | 12%
5000 | 140 | 5% | 12%
7500 | 214 | 5% | 12%
10000 | 273 | 5% | 12%

The following table lists the results for Change Status to Pending.

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 42 | 5% | 10%
2500 | 142 | 5% | 10%
5000 | 305 | 25% | 10%
7500 | 453 | 25% | 10%

The following table lists the results for Change Status to Released. Each item has at least 3 pending changes.

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 25 | <5% | 12%
2500 | 73 | <5% | 12%
5000 | 150 | 5% | 10%
7500 | 220 | <5% | 12%

#### 3.2.1.2 Item Object

The following table lists the results for Copy and Paste BOM.

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
500 | 15 | <5% | <5%
2500 | 70 | 15-20% | 5%
5000 | 150 | 15-20% | 5%

The following table lists the results for Expand BOM-All Levels.

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
3596 | 22 minutes | 75% | NA

Each page load took 5 seconds.

### 3.2.2 Product Quality Management

During the breakpoint testing for Product Quality Management, the table sizes used for testing purposes were as follows:

- PSR - 23908 items

- QCR - 23525 items

#### 3.2.2.1 PSR Object

The following table lists the results for Copy and Paste Affected Items (Newly Imported Items).

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 52 | 10% | 5%
2500 | 403 | 10-15% | 5%
3500 | 720 | 10-15% | 5%
5000 | Timed out after 23 minutes | 10-15% | 5%

The following table lists the results for Copy and Paste Affected Items (Existing Items).

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 302 | 10% | 5%
2500 | Timed out | 10-15% | 5%

#### 3.2.2.2 QCR Object

The following table lists the results for Copy and Paste Affected Items.

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
2500 | 360 | 10-15% | 5%
5000 | Timed out after 22 min | 10-15% | 5%

### 3.2.3 Product Portfolio Management

The following table lists the results for several PPM scenarios.

Scenarios | 1500 Object Tree(Response time in seconds) | 3000 Object Tree(Response time in seconds)
--- | --- | ---
Save As Project | 30 | 50
Save As Template | 18 | 35
Create Project From Template | 38 | 95
Add 10 Team Members | 21 | 42
Reschedule Root Project | 13 | 30
Reschedule Child | 11 | 24
Delegate Owner | 15 | 27
Substitute Resource | 11 | 24
Change Status | 18 | 30
Expand All (Web Client) | 160 | NA

Tree Details:

- 10 Team Members at each level

- 10 Links

- 10 Deliverables

- 10 External Dependencies

### 3.2.4 Product Governance & Compliance

The following tables list the results for several PG&C scenarios.

Note: Each declaration has 2 specs. Example: Dataset 1000=Declaration with 500 parts + 2 specs.

Table 3-1 Object: Declaration Tab Name: Items

Scenario | 250 Compositions | 500 Compositions | 1000 Compositions | App Server CPU Usage | DB Server CPU Usage
--- | --- | --- | --- | --- | ---
Copy & Paste Items | 12 | 25 | 35 | 15% | 5%
View Items Tab | 5 | 5 | 5 | NA | NA
Calculate Compliance | 1 | 1 | 1 | NA | NA
Release the Declaration | 40 | 72 | 150 | NA | 12%
Import Items (no BOS) | NA | NA | NA | NA | NA

Table 3-2 Object: Declaration Tab Name: Mfr Parts

Scenario | 250 Compositions | 500 Compositions | 1000 Compositions | App Server CPU Usage | DB Server CPU Usage
--- | --- | --- | --- | --- | ---
Copy & Paste Mfr Parts | 12 | 21 | 50 | 10-15% | 5%
View Mfr Parts Tab | 5 | 5 | 5 | NA | NA
Calculate Compliance | 4 | 4 | 4 | NA | NA
Release the Declaration | 40 | 75 | 90 | NA | 12%
Import Mfr Parts (no BOS) | NA | NA | NA | NA | NA

Table 3-3 Object: Declaration Tab Name: Part Groups

Scenario | 250 Compositions | 500 Compositions | 1000 Compositions | App Server CPU Usage | DB Server CPU Usage
--- | --- | --- | --- | --- | ---
Copy & Paste Part Groups | 12 | 22 | 50 | 10-15% | 5%
View Part Groups Tab | 5 | 5 | 5 | NA | NA
Calculate Compliance | 4 | 4 | 4 | NA | NA
Release the Declaration | 42 | 72 | 150 | NA | 12%
Import Part Groups (no BOS) | NA | NA | NA | NA | NA

Table 3-4 Object: Substance Groups Tab Name: Substances

Scenario | 50 Substances | 100 Substances
--- | --- | ---
Search & Add Substances | 6 | 8
View Substances tab | 3 | 3
Import Substances | 6 | 11

Table 3-5 Object: Specification Tab Name: Substances

Scenario | 50 Substances | 100 Substances
--- | --- | ---
Search & Add Substances and/or Groups | 6 | 8
View Substances tab | 3 | 3
Import Substance Groups | 6 | 9

#### 3.2.4.1 Product Governance & Compliance Nightly Rollup

Table 3-6 Stats to Rollup 109462 BOMs with 1 Spec

Total Time | Average App Server CPU | Average Database CPU
--- | --- | ---
14 Hours 30 Minutes | 15-20% | 12%

### 3.2.5 Product Cost Management

The following table lists the results for several PCM scenarios.

Action | Project with 2500 Items | Project with 5000 Items | BOM with 5000 Items | Project with 10000 Items
--- | --- | --- | --- | ---
Display project item tab | 4 | 7 | 4 | 9
Search and Add Items into project from PC item master | 41 | 65 | 22 | NA
Update item from PC item master | 31 | 48 | 70 | 117
Add/modify Partners (10) | 25 | 45 | 28 | 73
Import item from external source | 22 | 67 | 160 | NA
Export item to external source | 8 | 14 | 14 | 25
Project Save As | 22 | 110 | 300 | 420
Quantity rollup | 5 | 12 | 13 | 25
Display project AML tab | 5 | 7 | 5 | 6
Display item BOM | 5 | 7 | 4 | 9
Display of project analysis | 5 | 6 | 6 | 8
Opening Responses Look Up | 5 | 38 | 100 | 270
Project response price lookup | 12 | 16 | 57 | 200
Set as best | 21 | 45+55 (45 sec to open page + 55 to set as best) | 80+95 | 110+138
Publish Quote History, Authoring | 35+170 | 124+622 | 97+490 | 420 + Waited for 25 minutes
Publish Published Price Redlining | 40+165 | 120+600 | 108+500 | 290+Out of process memory
Items RFQ Creation | 30 | 153 | 110 | 306
Open RFQ | 15 | 50 | 45 | 95
Display of RFQ Responses | 15 | 21 | 10 | 24
Response Status Tab | 3 | 8 | 6 | 7
Opening RFQ Response Look Up | 12 | 38 | 105 | 260
RFQ Response Look Up | 9 | 17 | 120 | 215
RFQ Response Export | 18 | 56 | 57 | 107
RFQ Response Import | 35 | 120 | 80 | 270
RFQ Response status display | 3 | 8 | 6 | 7
Edit/Modify Responses | 14 | 53 | 35 | 180
Supplier Response Export | 19 | 45 | 35 | 87
Supplier Response Import | 37 | 104 | 73 | 220
Submit Responses | 19 | 53 | 35 | 104
Costed BOM Comparison (Buyer) Report | 9 | 20 | 7 | 14
Delete Project | 4 | 4 | 2 | 2
Close RFQ | 14 | 45 | 2 | 90
Close RFQ (after Lock RFQ) | 15 | 50 | 39 | 90
Delete RFQ | 35 | 40 | 35 | 85
Lock RFQ | 15 | 55 | 45 | 110
Analysis tab export | 32 | 93 | 90 | 180
Data Sets: Project with 2500 items, each having one AML Project with 5000 items, each having two AMLs Project with 10000 items, each having two AMLs Five-level BOM with a total of 5000 items and 2 AMLs for each leaf component. The top-level assembly contains 10 immediate children with each child having 5 immediate children.

### 3.2.6 Distributed File Manager

The breakpoint testing for distributed file manager tested file upload and download on the distributed file management server. Basic file upload and download was tested on both supported application servers without a web proxy. Advanced file upload and download was tested using the Java Client on both supported application servers with a web proxy.

The following tables list the results for file upload and download.

Note: Response time is measured in seconds.

Table 3-7 Basic File Upload and Download

Scenario | Response Time - Web Client | Response Time - Java Client | CPU Usage - Client | CPU Usage - DRM Server
--- | --- | --- | --- | ---
Upload - 1 GB | 96 | NA | <5% | 5-10%
Download - 1 GB | 155 | NA | 25% | 5-10%
Upload - 2 GB | Crashes | NA | NA | NA
Download - 2 GB | 357 | NA | 10% | 5%

The following table lists the results for advanced file upload and download.

Table 3-8 Basic File Upload and Download

Scenario | Response Time - Web Client | Response Time - Java Client | CPU Usage - Client | CPU Usage - DRM Server
--- | --- | --- | --- | ---
Upload - 5GB | 435 | 435 | <5% | 5%
Download -5GB | 153 | 152 | 15% | 10%

### 3.2.7 Export

Export was tested using the Web Client.

The following table lists the results for Export scenarios.

Table 3-9 Item/BOM Export Scenario

Scenario | Data Set | Response Time | JVM Heap | CPU Usage - App Server | CPU Usage - DB Server | Comments
--- | --- | --- | --- | --- | --- | ---
Export CSV | 4.8 Million Rows | 4 h 30 mins | 1200 MB | 20% continuous | <5% continuous | 6 level deep BOM Output file size: 3 GB
Export PDX/aXML | 4.8 Million Rows | 25 mins | 1200 MB | 20% continuous | <5% continuous | Same BOM as above. Duplicated rows won't be exported to PDX and aXML formats.

Table 3-10 Changes Export Scenario

Scenario | Data Set | Response Time | JVM Heap | CPU Usage - App Server | CPU Usage - DB Server | Comments
--- | --- | --- | --- | --- | --- | ---
Export CSV | 3000 rows | 3 h | 1200 MB | 20 % | <5% | NA

## 3.3 Solution Results on Solaris

The following tables show the results of breakpoint testing on the Product Collaboration, Product Quality Management, Product Portfolio Management, Product Cost Management solutions, and the Distributed File Manager component.

Breakpoint testing on the Solaris platform was performed on the following configuration:

- Application Server: v490, IV+ Processor, 4 CPU - 8 Core, 16 GB RAM, 1.5 GHz, 32 MB L2 Cache

- Database Server: v890, IV+ Processor, 8 CPU - 16 Core, 16 GB RAM, 1.5 GHz, 32 MB L2 Cache

Note: The response times for all of the tables are measured in seconds and are for single user only.

### 3.3.1 Product Collaboration

This section provides breakpoint testing results for Product Collaboration.

#### 3.3.1.1 Change Object

The following table lists the results for Copy and Paste Affected Items on Solaris.

Table 3-11 Results for Copy and Paste Affected Items on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
500 | 37 | 12% | <5%
2000 | 346 | 13% | <5%
3000 | Timed out | 14% | <5%

The following table lists the results for Save as Change on Solaris.

Table 3-12 Results for Save as Change on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 15 | 6% | 1%
2500 | 45 | 15% | 1%
5000 | 102 | 13% | 1%
7500 | 210 | 15% | 1%

The following table lists the results for Change Status to Released (with Preliminary Items) on Solaris.

Table 3-13 Results for Change Status to Released (with Preliminary Items) on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 7 | 7% | <5%
2500 | 20 | 12% | <5%
5000 | 44 | 10% | <5%
7500 | 62 | 13% | <5%

The following table lists the results for Change Status to Pending on Solaris.

Table 3-14 Results for Change Status to Pending on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 26 | 6% | <5%
2500 | 88 | 6% | <5%
5000 | 194 | 16% | <5%
7500 | 300 | 16% | <5%

The following table lists the results for Change Status to Released (each item has at least 3 pending changes) on Solaris.

Table 3-15 Results for Change Status to Released (each item has at least 3 pending changes) on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 9 | 4% | <5%
2500 | 22 | 6% | <5%
5000 | 46 | 11% | <5%

#### 3.3.1.2 Item Object

The following table lists the results for Copy and Paste BOM on Solaris.

Table 3-16 Results for Copy and Paste BOM on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
500 | 11 | 12% | 1%
2500 | 47 | 10% | 1%
5000 | 110 | 12% | 2%

The following table lists the results for Expand BOM (All Levels) on Solaris.

Table 3-17 Results for Expand BOM (All Levels) on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
3596 | 20 | 50% | NA

### 3.3.2 Product Quality Management

This section provides breakpoint testing results for Product Quality Management.

#### 3.3.2.1 PSR Object

The following table lists the results for Copy and Paste Affected Items (newly imported items) on Solaris.

Table 3-18 Results for Copy and Paste Affected Items (newly imported items) on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 51 | 9% | 1%
2500 | 451 | 10% | 1%
3500 | 748 | 10% | 1%
5000 | Timed out | 10% | 1%

The following table lists the results for Copy and Paste Affected Items (existing items) on Solaris.

Table 3-19 Results for Copy and Paste Affected Items (existing items) on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 261 | 4% | 1%
2500 | Timed out | 10% | 1%

#### 3.3.2.2 QCR Object

The following table lists the results for Copy and Paste Affected Items on Solaris.

Table 3-20 Results for Copy and Paste Affected Items on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
2500 | 390 | 9% | 1%
5000 | Timed Out | NA | NA

### 3.3.3 Product Portfolio Management

The following table lists the results of several PPM scenarios on Solaris.

Note: Response times are in seconds.

Table 3-21 PPM Scenarios on Solaris

Scenarios | 1200 Object Tree | 2400 Object Tree
--- | --- | ---
Save As Program | 36 | 55
Save As Template | 25 | 40
Create Project From Template | 42 | 99
Add 10 Team Members | 29 | 43
Reschedule Root Project | 17 | 34
Reschedule Child | 15 | 27
Delegate Owner | 18 | 29
Substitute Resource | 14 | 28
Change Status | 22 | 39
Expand All | 160 | Out of memory

Tree Details:

- 10 Team Members at each level

- 10 Links

- 10 Deliverables

- 10 External Dependencies

The following tables list the results for several PG&C scenarios.

Note: Each declaration has 2 specs. Example: Dataset 1000=Declaration with 500 parts + 2 specs.

Table 3-22 Object: Declaration Tab Name: Items

Scenario | 250 Compositions | 500 Compositions | 1000 Compositions | App Server CPU Usage | DB Server CPU Usage
--- | --- | --- | --- | --- | ---
Copy & Paste Items | 14 | 26 | 39 | 15% | 5%
View Items Tab | 4 | 4 | 4 | NA | NA
Calculate Compliance | 5 | 4 | 4 | NA | NA
Release the Declaration | 49 | 70 | 157 | NA | 12%
Import Items (no BOS) | NA | NA | NA | NA | NA

Table 3-23 Object: Declaration Tab Name: Mfr Parts

Scenario | 250 Compositions | 500 Compositions | 1000 Compositions | App Server CPU Usage | DB Server CPU Usage
--- | --- | --- | --- | --- | ---
Copy & Paste Mfr Parts | 12 | 22 | 52 | 10-15% | 5%
View Mfr Parts Tab | 4 | 6 | 6 | NA | NA
Calculate Compliance | 5 | 4 | 4 | NA | NA
Release the Declaration | 48 | 77 | 93 | NA | 12%
Import Mfr Parts (no BOS) | NA | NA | NA | NA | NA

Table 3-24 Object: Declaration Tab Name: Part Groups

Scenario | 250 Compositions | 500 Compositions | 1000 Compositions | App Server CPU Usage | DB Server CPU Usage
--- | --- | --- | --- | --- | ---
Copy & Paste Part Groups | 12 | 20 | 52 | 10-15% | 5%
View Part Groups Tab | 4 | 6 | 6 | NA | NA
Calculate Compliance | 4 | 4 | 4 | NA | NA
Release the Declaration | 49 | 75 | 156 | NA | 12%
Import Part Groups (no BOS) | NA | NA | NA | NA | NA

Table 3-25 Object: Substance Groups Tab Name: Substances

Scenario | 50 Substances | 100 Substances
--- | --- | ---
Search & Add Substances | 8 | 13
View Substances tab | 3 | 3
Import Substances | 8 | 14

Table 3-26 Object: Specification Tab Name: Substances

Scenario | 50 Substances | 100 Substances
--- | --- | ---
Search & Add Substances and/or Groups | 7 | 11
View Substances tab | 3 | 3
Import Substance Groups | 7 | 11

### 3.3.4 Product Cost Management

The following table lists the results for several PCM scenarios.

Note: Response times are in seconds.

Action | Project with 5000 Items | Project with 10000 Items
--- | --- | ---
Display project item tab | 6 | 5
Search and Add Items into project from PC item master | 57 | NA
Update item from PC item master | 45 | 194
Add/modify Partners (10) | 32 | 60
Import item from external source | 64 | 160
Export item to external source | 13 | 29
Project Save As | 210 | 545
Quantity rollup | 17 | 25
Display project AML tab | 4 | 6
Display item BOM | 6 | 5
Display of project analysis | 6 | 5
Opening Responses Look Up | 14 | 30
Project response price lookup | 14 | 26
Set as best | 37+47 | 80+105
Publish Quote History, Authoring | 47+45 | 163+75
Publish Published Price Redlining | 46+52 | 110+70
Items RFQ Creation | 45 | 110
Open RFQ | 10 | 110
Display of RFQ Responses | 4 | 6
Response Status Tab | 4 | 6
Opening RFQ Response Look Up | 10 | 16
RFQ Response Look Up | 55 | 98
RFQ Response status display | 4 | 6
Edit/Modify Responses | 150 | 550
Supplier Response Export | 135 | 480
Supplier Response Import | 90 | 180
Submit Responses | 88 | 510
Costed BOM Comparison (Buyer) Report | 25 | 45
Delete Project | 2 | 2
Close RFQ | 270 | 690
Delete RFQ | 30 | 33
Lock RFQ | 291 | 690
Data Sets: Project with 5000 items, each having two AMLs Project with 10000 items, each having two AMLs

### 3.3.5 Distributed File Manager

The breakpoint testing for distributed file manager tested file upload and download on the distributed file management server. Basic file upload and download was tested on both supported application servers without a web proxy. Advanced file upload and download was tested using the Java Client on both supported application servers with a web proxy.

The following table lists the results for basic file upload and download.

Table 3-27 Basic File Upload and Download

Scenario | Response Time - Web Client | Response Time - Java Client | CPU Usage - Client | CPU Usage - DFM Server
--- | --- | --- | --- | ---
Upload - 1 GB | 93 | NA | <5% | 5%
Download - 1 GB | 160 | NA | 25% | 5%
Upload - 2 GB | Crashes | NA | NA | NA
Download - 2 GB | 349 | NA | 10% | 5%

The following table lists the results for advanced file upload and download.

Table 3-28 Basic File Upload and Download

Scenario | Response Time - Web Client | Response Time - Java Client | CPU Usage - Client | CPU Usage - DFM Server
--- | --- | --- | --- | ---
Upload - 5GB | 441 | 429 | <5% | 5%
Download -5GB | 161 | 157 | 15% | 5%

### 3.3.6 Export

Export was tested using the Web Client.

The following table lists the results for Export scenarios.

Table 3-29 Items/BOM Export Scenario

Scenario | Data Set | Response Time | JVM Heap | CPU Usage - App Server | CPU Usage - DB Server | Comments
--- | --- | --- | --- | --- | --- | ---
Export CSV | 4.8 Million Rows | 4 h 30 mins | 1200 MB | 20% continuous | <5% continuous | 6 level deep BOM Output file size: 3 GB
Export PDX/aXML | 4.8 Million Rows | 25 mins | 1200 MB | 20% continuous | <5% continuous | Same BOM as above. Duplicated rows won't be exported to PDX and aXML formats.

Table 3-30 Changes Export Scenario

Scenario | Data Set | Response Time | JVM Heap | CPU Usage - App Server | CPU Usage - DB Server | Comments
--- | --- | --- | --- | --- | --- | ---
Export CSV | 3000 Rows | 3 h | 1200 MB | 20 % | <5% | NA

## 3.4 Solution Results on AIX

The following tables show the results of breakpoint testing on the Product Collaboration, Product Quality Management, and the Distributed File Manager component.

Breakpoint testing on the AIX platform was performed on the following configuration:

- Application Server: PowerPC_Power6, P6 Processor, 4.7 GHz, 4 Cores, 16 GB RAM

- Database Server: PowerPC_Power6, P6 Processor, 4.7 GHz, 4 Cores, 16 GB RAM

Note: The response times for all of the tables are measured in seconds and are for single user only.

### 3.4.1 Product Collaboration

This section provides breakpoint testing results for Product Collaboration.

#### 3.4.1.1 Change Object

The following table lists the results for Copy and Paste Affected Items on AIX.

Table 3-31 Results for Copy and Paste Affected Items on AIX

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
500 | 32 | 22% | 5%
2000 | 255 | 25% | 5%
3000 | 700 | 25% | 5%
5000 | Timed out after 15 min | 25% | 5%

The following table lists the results for Save as Change on AIX.

Table 3-32 Results for Save as Change on AIX

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 12 | 15% | 5%
2500 | 41 | 15-25% | 5%
5000 | 87 | 15-25% | 5%
7500 | 168 | 15-25% | 5%

The following table lists the results for Change Status to Released (with Preliminary Items) on AIX.

Table 3-33 Results for Change Status to Released (with Preliminary Items) on AIX

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 12 | 10% | 5%
2500 | 20 | 10% | 5%
5000 | 41 | 25% | 5%
7500 | 70 | 25% | 12%

The following table lists the results for Change Status to Pending on AIX.

Table 3-34 Results for Change Status to Pending on AIX

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 31 | 10% | 6%
2500 | 85 | 25% | 6%
5000 | 185 | 25% | 6%
7500 | 300 | 25% | 6%

The following table lists the results for Change Status to Released (each item has at least 3 pending changes) on AIX.

Table 3-35 Results for Change Status to Released on AIX

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 10 | 10% | 10-15%
2500 | 21 | 10% | 10-15%
5000 | 43 | 10% | 10-15%
750 | 10 | 10% | 10-15%

#### 3.4.1.2 Item Object

The following table lists the results for Copy and Paste BOM on AIX.

Table 3-36 Results for Copy and Paste BOM on AIX

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
500 | 11 | 15% | <5%
2500 | 50 | 15-25% | <5%
5000 | 107 | 15-25% | 5-10%

The following table lists the results for Expand BOM (All Levels) on AIX.

Table 3-37 Results for Expand BOM (All Levels) on AIX

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
3596 | 18 | 10% | <5%

### 3.4.2 Product Quality Management

This section provides breakpoint testing results for Product Quality Management.

#### 3.4.2.1 PSR Object

The following table lists the results for Copy and Paste Affected Items (Newly Imported Items).

Table 3-38 Results or Copy and Paste Affected Items (Newly Imported Items)

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 48 | 10% | 5%
2500 | 355 | 10% | 5%
3500 | 710 | 10% | 5%
5000 | Timed out after 15 minutes | 10% | 5%

The following table lists the results for Copy and Paste Affected Items (Existing Items).

Table 3-39 Results for Copy and Paste Affected Items (Existing Items)

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
750 | 292 | 5% | 2%
2500 | Timed out after 15 minutes | NA | NA

#### 3.4.2.2 QCR Object

The following table lists the results for Copy and Paste Affected Items on Solaris.

Table 3-40 Results for Copy and Paste Affected Items on Solaris

Number of Affected Items | Response Time (in seconds) | CPU Usage - Application Server | CPU Usage - Database
--- | --- | --- | ---
2500 | 320 | 10% | 5%
5000 | Timed Out after 15 minutes | NA | NA

### 3.4.3 Distributed File Manager

The breakpoint testing for distributed file manager tested file upload and download on the distributed file management server. Basic file upload and download was tested on both supported application servers without a web proxy. Advanced file upload and download was tested using the Java Client on both supported application servers with a web proxy.

The following table lists the results for basic file upload and download.

Table 3-41 Basic File Upload and Download

Scenario | Response Time - Web Client | Response Time - Java Client | CPU Usage - Client | CPU Usage - DFM Server
--- | --- | --- | --- | ---
Upload - 1 GB | 45 | NA | 11% | 10%
Download - 1 GB | 10 | NA | 15% | 5%
Upload - 2 GB | 86 | NA | 11% | 5%
Download - 2 GB | 30 | NA | 50% | 5%

The following table lists the results for advanced file upload and download.

Table 3-42 Basic File Upload and Download

Scenario | Response Time - Web Client | Response Time - Java Client | CPU Usage - Client | CPU Usage - DFM Server
--- | --- | --- | --- | ---
Upload - 7 GB | 205 | 255 | 10% | 12%
Download - 7 GB | 160 | 156 | 15-25% | 20%

### 3.4.4 Export

Export was tested using the Web Client.

The following table lists the results for Export scenarios.

Table 3-43 Changes Export Scenario

Scenario | Data Set | Response Time | CPU Usage - App Server | CPU Usage - DB Server
--- | --- | --- | --- | ---
Export - CSV | 3500 | 30 | <10% | <2%
Export - PDX | 3500 | 35 | <10% | <2%