When the number of results from a query is very high (hundreds of M or more on my system), the time taken to write out the results is very slow. The time taken is not linearly proportional to the size of results.