Advanced Performance Tuning Guide

Back Next

DX_Add_Document_To_Event Transformation

The following table lists the transformation benchmark test results for an Oracle database with the Linux operating system:

Processing Type	Files	Rows	Events	Row Size	Minutes	Seconds	Throughput
By Reference to Different events	10	10000	100000	1KB	3	53	429
By Reference to Different events	1	100000	100000	1KB	2	30	667
By Value to Different Events	10	10000	100000	1KB	1	48	926
By Value to Different Events	1	100000	100000	1KB	0	37	2667
By Value to Different Events	10	10000	100000	10KB	3	5	540
By Value to Different Events	1	100000	100000	10KB	2	57	565
By Value to Different Events	10	2000	20000	100KB	3	41	90
By Value to Different Events	1	20000	20000	100KB	3	10	105
By Value to Different Events	10	300	3000	1MB	9	50	5
By Value to Different Events	1	3000	3000	1MB	7	47	6
By Value to Same Event	10	300	3000	1MB	5	43	9
By Value to Same Event	1	3000	3000	1MB	6	25	8

The following table lists the transformation benchmark test results for a Microsoft SQL Server database with the Windows operating system:

Processing Type	Files	Rows	Events	Row Size	Minutes	Seconds	Throughput
By Reference to Different events	10	10000	100000	1KB	4	55	339
By Reference to Different events	1	100000	100000	1KB	2	50	588
By Value to Different Events	10	10000	100000	1KB	0	49	2041
By Value to Different Events	1	100000	100000	1KB	0	31	3226
By Value to Different Events	10	10000	100000	10KB	1	38	1020
By Value to Different Events	1	100000	100000	10KB	1	33	1075
By Value to Different Events	10	2000	20000	100KB	2	24	138
By Value to Different Events	1	20000	20000	100KB	2	32	131
By Value to Different Events	10	300	3000	1MB	7	40	7
By Value to Different Events	1	3000	3000	1MB	2	0	25
By Value to Same Event	10	300	3000	1MB	4	8	12
By Value to Same Event	1	3000	3000	1MB	5	40	9