Dynamics AX 2012 – DIXF Performance Benchmark Results

The Dynamics AX InMarket team has provided the following benchmarking results for DIXF imports based on numerous requests for this information. If there are any questions or requests for additional entity coverage please let me know!

Problem Statement:

Customer is importing around 500K records and the need for some form of benchmarking the performance expected out of importing/exporting using DIXF.

This article answer customer’s questions about what kind of performance they could expect out of DIXF.

Machine Configuration

Below was the machine configuration on which the benchmark testing was performed.

Entities

Microsoft performed the benchmark performance testing for below entities with different amount of data in each iteration. Similar iterations was performed with different numbers of batch tasks.

Results

Below are the results for each entity when run under the batch execution with different tasks/record counts.

Opening Balance Entity (Batch Execution)

Entity	No. of Tasks	Record Count	Staging Execution Time	Target Execution Time
Opening Balance	32	1500 (3 lines per journal)	3 sec	24 sec
	32	3000 (3 lines per journal)	4 sec	32 sec
	32	6000 (3 lines per journal)	9 sec	59 sec
	32	12000 (3 lines per journal)	9 sec	2 min 2 sec
	32	24000 (3 lines per journal)	15 sec	5 min 28 sec

Execution details with different numbers of tasks.

Product Entity (Batch Execution)

Entity	No. of Tasks	Record Count	Staging Execution Time	Target Execution Time
Product	32	5000	6 sec	2 min 45 sec
	32	10000	9 sec	5 min 26 sec
	32	20000	17 sec	11 min 13 sec
	32	40000	37 sec	26 min 41 sec
	32	80000	1 min 3 sec	58 min 37 sec

Execution details with different numbers of tasks.

Sales Order Header (Batch Execution)

Entity	No. of Tasks	Record Count	Staging Execution Time	Target Execution Time
Sales Order Header	32	1000	3 sec	7 sec
	32	2000	3 sec	11 sec
	32	4000	4 sec	21 sec
	32	8000	5 sec	40 sec
	32	16000	7 sec	1 min 40 sec

Sales Order Line (Batch Execution)

Entity	No. of Tasks	Record Count	Staging Execution Time	Target Execution Time
SALES Order Line	32	5000	5 sec	48 sec
	32	10000	7 sec	1 min 49 sec
	32	20000	10 sec	3 min 47 sec
	32	40000	23 sec	7 min 28 sec
	32	80000	42 sec	17 min 1 sec

Sales Order Composite Entity (Batch Execution)

Entity	Sub Entity	Record Count	No. of Tasks	Staging Execution Time	Target Execution Time
Sales Order	SOH	1000	10	16 sec	2 min 13 sec
	SOL	5000	22
	SOH	2000	10	34 sec	4 min
	SOL	10000	22
	SOH	4000	10	1 min	8 min 34 sec
	SOL	20000	22
	SOH	8000	10	2 min 15 sec	18 min 16 sec
	SOL	40000	22
	SOH	16000	10	3 min 38 sec	38 min 19 sec
	SOL	80000	22

Execution details with different numbers of tasks.

Vendor Invoice Header (Batch Execution)

Entity	No. of Tasks	Record Count	Staging Execution Time	Target Execution Time
Vendor Invoice Header	32	500	2 sec	4 sec
	32	1000	2 sec	6 sec
	32	2000	2 sec	10 sec
	32	4000	3 sec	17 sec
	32	8000	4 sec	41 sec

Vendor Invoice Line (Batch Execution)

Entity	No. of Tasks	Record Count	Staging Execution Time	Target Execution Time
Vendor Invoice Line	32	1500	3 sec	24 sec
	32	3000	4 sec	41 sec
	32	6000	3 sec	1 min 23 sec
	32	12000	6 sec	2 min 44 sec
	32	24000	8 sec	5 min 51 sec

Vendor Invoice Composite Entity (Batch Execution)

Entity	Sub Entity	Record Count	No. of Tasks	Staging Execution Time	Target Execution Time
Vendor Invoice	VIH	500	10	3 sec	33 sec
	VIL	1500	22
	VIH	1000	10	11 sec	1 min
	VIL	3000	22
	VIH	2000	10	20 sec	1 min 56 sec
	VIL	6000	22
	VIH	4000	10	35 sec	3 min 54 sec
	VIL	12000	22
	VIH	8000	10	1 min 13 sec	7 min 58 sec
	VIL	24000	22

Execution details with different numbers of tasks.