A colleague has challenged me with an interesting question. To be honest I have no idea how to deal with it. 

Suppose the following:

> 
> Every 5 minutes you get a new file with one hundred thousand new
>  records. You need to store the records in a database table within
>  these 5 minutes.
> 
> 
> 

* First, I'd stream that file because loading up everything in memory may cause a stack overflow
* Second, inserting data in a batch way

What coding strategy would you use to cope with the amount of data and to stay within this short timeframe for each file you receive?