Campaign Response Taking Longer

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Campaign Response Taking Longer

Postby Yanela08 » Mon Jun 29, 2020 12:20 pm

Hello. When I click on the campaign setup on the system, it takes about 5 or more seconds before it populates and 10 seconds on clicking DETAILS. It has lists of 330K dialables leads combined. Thank you.

ViciBox v.9.0.2 200415-1712
VERSION: 2.14-757a
BUILD: 200619-1643
Asterisk 13.29.2-vici
1 Data/Web-6 cores 16gb
3 Telephony-6 cores 8gb
Cloud
SSD
Last edited by Yanela08 on Mon Jun 29, 2020 9:56 pm, edited 1 time in total.
Yanela08
 
Posts: 97
Joined: Tue Feb 24, 2009 11:06 pm

Re: Campaign Response Taking Longer

Postby Yanela08 » Mon Jun 29, 2020 3:07 pm

Anybody encountered this before and could share about what they've done to resolve it? Thank you.
Yanela08
 
Posts: 97
Joined: Tue Feb 24, 2009 11:06 pm

Re: Campaign Response Taking Longer

Postby mflorell » Mon Jun 29, 2020 4:29 pm

How many total leads?

Please post your database hardware specs, including drives and RAID.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Campaign Response Taking Longer

Postby williamconley » Mon Jun 29, 2020 4:32 pm

Cloud

um ... you mean "virtual server instace" hosted at Amazon? Be specific ... it matters.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Campaign Response Taking Longer

Postby Yanela08 » Mon Jun 29, 2020 9:54 pm

Hi Matt, it has 320K total leads.
320 GB SSD, 6 CPU, 16GB RAM.

@William, yes, its virtual server instance hosted at Vultr.

Thank you.
Yanela08
 
Posts: 97
Joined: Tue Feb 24, 2009 11:06 pm

Re: Campaign Response Taking Longer

Postby Yanela08 » Thu Jul 02, 2020 7:34 am

Are my resources not adequate? Thanks.
Yanela08
 
Posts: 97
Joined: Tue Feb 24, 2009 11:06 pm

Re: Campaign Response Taking Longer

Postby carpenox » Thu Jul 02, 2020 8:07 am

they are, however virtual servers are less stable and have been known to come across issues. I found that out the hard way lol
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Campaign Response Taking Longer

Postby Yanela08 » Fri Jul 03, 2020 9:33 am

Thanks. Did this occur to you also before? Where only by clicking CAMPAIGN that it takes longer for just 320k leads? If so, what steps did you take to resolve it.

Regards.
Yanela08
 
Posts: 97
Joined: Tue Feb 24, 2009 11:06 pm

Re: Campaign Response Taking Longer

Postby carpenox » Fri Jul 03, 2020 1:04 pm

Yes the more leads the slower it loads especially in virtual. Try putting some inactive if they're separate lists...
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Campaign Response Taking Longer

Postby williamconley » Thu Jul 16, 2020 1:07 pm

carpenox wrote:Yes the more leads the slower it loads especially in virtual. Try putting some inactive if they're separate lists...

changing to inactive has no effect. that changes a "Y" to an "N" in the "vicidial_lists" table without altering the size of "vicidial_list" (Note the missing "s"). Which means any query running on the vicidial_list table will not even notice the difference, as a rule. If you verify the time of the mysql response, there isn't likely to be a difference until you delete leads (or move them to an archived leads table) and optimize vicidial_list.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Campaign Response Taking Longer

Postby carpenox » Thu Jul 16, 2020 9:30 pm

thanks Bill, i didnt realize that, i was figuring with them inactive it would try to pull any information on them from the db
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Campaign Response Taking Longer

Postby williamconley » Fri Jul 17, 2020 10:34 am

carpenox wrote:thanks Bill, i didnt realize that, i was figuring with them inactive it would try to pull any information on them from the db

That's why I mentioned it. It's an easy assumption to make, and to test. Note that you are partially right: It does not try to get that information from the DB. But it has to sort through that information to get what it does need. Finding my mom at the train station is a lot easier when she's the only one there. When the place is packed nut-to-butt with peeople it's nearly impossible. 8-) It's not about what you're looking for, it's about the data set being searched. Wait! I got another one: Find the needle on the sewing table vs the haystack? lol
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Campaign Response Taking Longer

Postby carpenox » Fri Jul 17, 2020 11:11 am

LMAO @ nut-to-butt

good shit
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to Support

Who is online

Users browsing this forum: No registered users and 91 guests