AnsweredAssumed Answered

Slowly importing records

Question asked by PeterDurant on Jul 27, 2013
Latest reply on Jul 31, 2013 by PeterDurant

Title

Slowly importing records

Post

     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?

Outcomes