VoiceGuide IVR Software Main Page
Jump to content

Loading Phone Number Using Xml Too Slow

Recommended Posts

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

Share this post


Link to post

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).

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×