First, it doesn't free memory when it is done, and it uses it a lot.I've already loaded 100MB files in less than 30s using this technique.
Second, it lasts an eternety to insert all the data.
Does anybody have any idea how to optimize it?
It looks like insert clause is creating this delay. What do you think?Any trigger on the table?
Why is inserting this records also creating memory leak?Which memory area are you talking about?