Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: vma on July 08, 2010, 03:12:30 PM

Title: Contact list of 75k entries
Post by: vma on July 08, 2010, 03:12:30 PM

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

Title: Re: Contact list of 75k entries
Post by: victor on July 08, 2010, 05:53:42 PM

Well, it all depends on how you will implement it but my instant answer is ... why???

It should significantly slow down GAD.

Title: Re: Contact list of 75k entries
Post by: René on July 08, 2010, 09:10:10 PM

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.

Title: Re: Contact list of 75k entries
Post by: vma on July 09, 2010, 01:50:41 PM

Thank you very much for your answer!