All tests were conducted five times, and the elapsed time for each test run was recorded. The lowest and highest times were discarded, and the average of the middle three were computed and rounded to the nearest second. This is the number displayed in the following tables under

Average Time

.

Rows/Second

is shown to provide a normalized number to compare test performance across different row counts and test types. The ideal situation is to have a consistent (that is, flat) measure for rows per second as the number of rows increases for a given test scenario. This shows linear scalability for the system.

The joined column in the following tables indicates whether a join condition was defined across the table pair.