Hello again,
I have to import the list of contacts my customer has so I plan to make an sql script to put them all in the data base. Anyone has experience with this and knows if such a big list will slow down GAD?
Thank you,
Mihai
Well, it all depends on how you will implement it but my instant answer is … why???
It should significantly slow down GAD.
1 Like
Hi Mihai,
75k contacts isn’t too much. I worked for a customer having over 4 millions contacts in UCS database and size of UCS databases (Main + Archive) was over 2TB (yes, two terabytes) 
Back to yr question - I did something very similar in the past and SQL script is the fastest way as it will take forever using Contacts Platform SDK. As I wrote 75k contacts should not impact GAD during normal operations. Of course, contact search will take longer.
There is one very important thing - it is necessary to rebuild indexes after the import is done and maintain the indexes regularly.
R.
1 Like
Thank you very much for your answer!
1 Like