I do not understand why did you validate structure to make insert fast.
You did not tell us how many number of records in test db and exactly how long it took.
I assume in test db there are around 100,000 records in same table and took around 1min. so that will be 500 min for a 50 million records.




Reply With Quote