campaign + list limits

[callcen]

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.

[williamconley]

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.

[callcen]

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.

[mflorell]

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.

[williamconley]

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.