Author Topic: Contact list of 75k entries  (Read 2491 times)

Offline vma

  • Sr. Member
  • ****
  • Posts: 255
  • Karma: 0
Contact list of 75k entries
« on: July 09, 2010, 12:12:30 AM »
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

Offline victor

  • Administrator
  • Hero Member
  • *****
  • Posts: 1410
  • Karma: 18
Re: Contact list of 75k entries
« Reply #1 on: July 09, 2010, 02:53:42 AM »
Well, it all depends on how you will implement it but my instant answer is ... why???

It should significantly slow down GAD.

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: Contact list of 75k entries
« Reply #2 on: July 09, 2010, 06:10:10 AM »
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.

Offline vma

  • Sr. Member
  • ****
  • Posts: 255
  • Karma: 0
Re: Contact list of 75k entries
« Reply #3 on: July 09, 2010, 10:50:41 PM »
Thank you very much for your answer!