Steve, It's a good solution. THANKS!!!
Tried using command line...
But I can't understand the logic...
I had 1.6GB file with 42 000 000 records in it. Trough command line, it was uploaded in 40 minutes (GREAT!)
BUT
I have 3GB file with around 80 000 000 records. Started it, and 4 hours later it wasn't uploaded yet. So I decided to slice it into pieces - 8 x 10 000 000 records (each file is around 400M
. I've started uploading the first 2 HOURS ago and it's still uploading!?
Am I missing something here? WHY 1.6GB file with 42 mln records is uploaded in 40 minutes and 0.4GB file with only 10 mln records is uploading so slow?!
The 2 tables in the database have simillar number and type of fields - first (42 mln) has 6 fields, and the second one has 5 fields.