I thought I would set my self a challenge.

Create 1 million records in a table, in the fastest way possible.

Only rules are – there can be no records when the timer starts, that includes in external data sources.
So you can not already have set ready – it must be created after the timer starts.

This file demonstrates a method for creating 1 Million Records, fast.

Even on my old laptop 1 Million Records can be created in under 1 minute 45seconds.

While it seems like an easy task – if you don’t do some research, it can take hours.

The first port of call people think of is lets make a script:

$loop = 0
   Loop   
   New Record
   $loop = $loop + 1
   exit Loop if $loop > 1,000,000
End Loop

rational thought – but this definitely takes more than 2 minutes

This method can also be used to set a variable with 1 million UUIDs in less than 20 seconds