All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by callcen » Thu Nov 08, 2012 10:19 am
Got a question for all you vicidial experts; is there a limit to how many lists you can load up and how many campaigns you can create.
I dont mean the load on the server, so i'm not talking about real time load becuase of too many campaigns running at the same time or anything like that, i just mean a hard limit set to how many you can actually have created and have in the system at the same time. I have a client that is using vicidial to run a campaign per post code so they end up with a lot of campaings.
The client asked me this question and i have no idea, i'm leaning towards saying no since it doesnt seem likely there would be but just wanted to be sure before i go back to them.
Vicidial Redux
VERSION: 2.6-370a
BUILD: 120529-2112
Asterisk 1.4
-
callcen
-
- Posts: 9
- Joined: Mon Apr 23, 2012 8:37 pm
by williamconley » Thu Nov 08, 2012 8:08 pm
bigint(14) is the data type for list_id. This is ... a really freakin big number. So for the sake of argument, no. Campaign_id is a character string, so once again: no limit.
I have had clients whose list display screen became unwieldy after too many leads/lists were loaded because the screen counts the leads during display (if you want to view the "lists" menu ... it may hammer the cpu and take a while from all the reads/counts). From what I understand the latest code has an option to turn off the "counter" on that page so the quantity of leads in each list is now shown, which should resolve that issue quite well.
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: 20278
- Joined: Wed Oct 31, 2007 4:17 pm
- Location: Davenport, FL (By Disney!)
-
by callcen » Thu Nov 08, 2012 11:02 pm
Thanks for that, i thought it was the case but didnt want to go back and say no limits and then find myself in a hole i dug.
I did read a post a day or so ago about turning off the counter and booked marked it for later in case i run into that, i can see that might become an issue with this client.
The client wants to keep all her data for atleast 2 years so by that stage they are going to have a massive set of lists, i might export out her database and load it up on a VM i have and tell her to start deleting lists/campaigns they arent currently using if we do run into it. That way we still have her data and she can still access it if needed but the system wont be put under load.
Thanks for the advice, appreciate it.
Vicidial Redux
VERSION: 2.6-370a
BUILD: 120529-2112
Asterisk 1.4
-
callcen
-
- Posts: 9
- Joined: Mon Apr 23, 2012 8:37 pm
by mflorell » Fri Nov 09, 2012 7:16 am
The largest number of leads I have seen on a client system was upwards of 23,000,000
The largest number of lists I have seen on a client system was upwards of 500
The largest number of campaigns I have seen on a client system was upwards of 280(most were inactive)
Of course the clients had database server hardware capable of handling these, but these systems did operate properly.
-
mflorell
- Site Admin
-
- Posts: 18387
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
-
by williamconley » Fri Nov 09, 2012 7:08 pm
We do have a few clients that push all records to a slave server and report there ... and they never delete anything from the slave server (ever). The added advantage: run huge reports in the middle of the workday with no effect on the system. The disadvantage: those reports will only be as far up to date as the last "push". Even replication has a delay factor, and many don't use replication but simple query pushes.
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: 20278
- Joined: Wed Oct 31, 2007 4:17 pm
- Location: Davenport, FL (By Disney!)
-
Return to Support
Who is online
Users browsing this forum: No registered users and 70 guests