Slowly importing records
My contact management database currently has 1.2 million records with 240 fields of various types. The database size is about 3Gig and is hosted on a cloud server.
I am loading in about 150,000 new contacts at a time until I get to the point of about 3 million records. In order to load the records I have to upload the database from the server to my computer, load the records and then download back to the server since if I try to load to the server it always times out.
That's not so much a problem but here IS the problem: With each new 150,000 records the loading process gets slower - much slower. It now takes 24 hours to load these records. The last batch took about 18 hours. By the time I get to the last set of 150,000 records it will take a week to load! Does anyone have any suggestions that might speed this up?