Loading Phone Number Using Xml Too Slow

[mediasol]

Loading large phone number list using xml is every slow.

 

It took over 2 hours for the Vg to load a xml file with 8000 records into a MYsql database.

 

Can we change any database setting to increase speed?

ZZZmbscall_09_07_12_08_17.zip

[SupportTeam]

It should not take that long (8000 database inserts over 120 minutes is about 1 db insert per second. A database should accept inserts a lot faster then that). Can you post the VgEngine trace which covers that loading time?

 

Which version of MySQL are you using? Is the database on the same server as VoiceGuide?

 

How long does it take to load 10,000 numbers into your database using the Telephone Number Loader app?

Do a test load specifying this as a number:

 

1XXXX

 

This will result in 10,000 numbers (from 10000 to 19999) being loaded.

(specify some unique CampaignName and an Activation time far into the future. Then you can delete the test entries by deleting all entries from PortToUse and CallQue which have this this CampaignName).