Data Validation Option Best Practices

Back Next

Fifty Value Tests

This scenario contains 50 value tests, one count, and one outer value. This is a typical set of tests that can be automatically generated for a table pair in Data Validation Option. Note that the rows per second drops by about 10 times as compared to the 5-value test scenario. This is expected given the fixed capacity of the server and the 10-times increase in the number of columns testing. But comparisons per second remains high. On average, comparisons per second remains slightly higher in the 50-value tests when compared to the 5-value test scenario.

Joined	Rows	Columns	Test Types	Average Time	Rows/Second	Comparisons/Second
Yes	1,000,000	50	Fifty value, one count, one outer value	3 minutes 49 seconds	4,367	218,340
Yes	2,000,000	50	Fifty value, one count, one outer value	12 min 14 sec	2,725	136,239
Yes	5,000,000	50	Fifty value, one count, one outer value	30 min 20 sec	2,747	137,337
Yes	10,000,000	50	Fifty value, one count, one outer value	53 min 29 sec	3,117	155,827

Rename Saved Search

Table of Contents

Data Validation Option Best Practices

Data Validation Option Best Practices

Fifty Value Tests

Fifty Value Tests