Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Corrected links that should have been relative instead of absolute.

...

Click here to open the test results page. 

Test G - Schema

Sl. No.Test Case DescriptionData Set
(File
Size)
Execution Time
1      

To test processing of simple Excel file (xls) through File Event, File Source and File target 


Process Flow:

Performance_Process_flow_Excel

100 MB      

1 min 28 sec 

Kernel CPU: 25%
WebRunner CPU: 0.00%

Kernel Mem: 5.5GB
WebRunner Mem: 854MB

 2To test processing of simple Positional file through File Event, File Source and File target 


Process Flow:

Performance_Process_flow_Positional

 100 MB

59 sec 

Kernel CPU: 27%
WebRunner CPU: 0.00%

Kernel Mem: 7.21GB
WebRunner Mem: 855MB

 3To test processing of simple JSON file through File Event, File Source and File target 


Process Flow:

Performance_Process_flow_JSON

 100 MB

25 sec 

Kernel CPU: 3%
WebRunner CPU: 0.03%

Kernel Mem: 8.7GB
WebRunner Mem: 855MB

 4To test processing of simple Adv Positional file through File Event, File Source and File target 


Process Flow:

Performance_Process_flow_Adv_Positional

 100 MB

1 min 15 sec 

Kernel CPU: 29%
WebRunner CPU: 0.00%

Kernel Mem: 8.2GB
WebRunner Mem: 830MB

5To test processing of simple Text file through File Event, File Source and File target 


Process Flow:

Performance_Process_flow_Text

 100 MB

2 min 00 sec 

Kernel CPU: 28.5%
WebRunner CPU: 0.00%

Kernel Mem: 8.5GB
WebRunner Mem: 855MB

6To test processing of simple Adv. Text file through File Event, File Source and File target 


Process Flow:

Performance_Process_flow_adv_text

100 MB

1 min 49 sec 

Kernel CPU: 25%
WebRunner CPU: 0.00%

Kernel Mem: 8.6GB
WebRunner Mem: 856MB

7To test processing of simple xml file through File Event, File Source and File target 


Process Flow:

Performance_Process_flow_Xml

100 MB

7 sec 

Kernel CPU: 19%
WebRunner CPU: 0.3%

Kernel Mem: 8.85GB
WebRunner Mem: 855MB

8

To test Database Event along with Adv Database Source when the number of records to pick up are large in the table. Use one to map to write data to Adv DB target with different batch/commit size options.


Process Flow:

Performance_Process_flow_Adv_Database

50000 records to pickup Batch size=5000

Commit Size=2500

1 min 36 sec 

Kernel CPU: 19.8%
WebRunner CPU: 0.00%

Kernel Mem: 3.56GB
WebRunner Mem: 841MB

9

To test Database Event along with Adv Database Source when the number of records to pick up are large in the table. Use one to map to write data to Adv DB target with different batch/commit size options.


Process Flow:

Performance_Process_flow_Adv_Database

50000 records to pickup Batch size=5000

Commit Size=5000

1 min 40 sec 

Kernel CPU: 20.2%
WebRunner CPU: 0.00%

Kernel Mem: 3.34GB
WebRunner Mem: 839MB


Test H - Miscellaneous

Sl. No.Test Case DescriptionData Set
(File
Size)
Execution Time
1To test concurrent processing of flat files of different sizes with moderate mapping functions and one to one conversion.

File Type: CSV

File Size: 1MB

Concurrent Files: 500

2 min 54 sec 

Kernel CPU: 5.20%
WebRunner CPU: 0.00%

Kernel Mem: 3.33GB
WebRunner Mem: 824MB

2To test concurrent processing of flat files of different sizes with moderate mapping functions and one to one conversion.

File Type: CSV

File Size: 1MB

Concurrent Files: 1000

9 min 32 sec 

Kernel CPU: 5.82%
WebRunner CPU: 0.00%

Kernel Mem: 3.34GB
WebRunner Mem: 834MB

3To test concurrent processing of flat files of different sizes with moderate mapping functions and one to one conversion.

File Type: CSV

File Size: 100KB

Concurrent Files: 5000


4

To test processing of flat files located at File through non-streaming Mapping with pre-built Mapping functions applied (string, conditional, date, math) and generate the Target file.

100MB Plain CSV Text file

Non-streaming Mapping mode

1 min 40 sec 

Kernel CPU: 2.5%
WebRunner CPU: 0.00%

Kernel Mem: 3.37GB
WebRunner Mem: 836MB