Page 1 of 1

LARGE databases

PostPosted: Thu Feb 02, 2012 3:14 am
by noworldorder
I have been told not to use lists with more that 10000 records. Is this true? I would like to have a list of 60000 records. Is there a way I can do this without any issues?

PostPosted: Thu Feb 02, 2012 5:38 am
by sobek
I don't know if it is good practice but I have lists biger then 150 000 and 3341882 in vicidial_list and I have no issues with that.

PostPosted: Thu Feb 02, 2012 9:38 pm
by mflorell
As long as your system is properly configured you can have millions of leads in a single list if your hardware supports it.

Re: LARGE databases

PostPosted: Thu Feb 02, 2012 10:21 pm
by williamconley
noworldorder wrote:I have been told not to use lists with more that 10000 records. Is this true? I would like to have a list of 60000 records. Is there a way I can do this without any issues?
WHO told you that? Consider it debunked. Completely false statement.

PostPosted: Thu Feb 02, 2012 11:37 pm
by noworldorder
[quotey ]WHO told you that? [/quote]

My IT... but we all make mistakes

Re: LARGE databases

PostPosted: Thu Sep 27, 2012 9:56 am
by porpoise3
If I have a large list of 700,000 and 500,000...I have no problem with running the list and the calling of the list, however, I just can't download the list because everytime I try it returns 0 bytes. (to large for notepad ??)...So how would I dowload these lists so I can "break" them up into smaller lists and re-upload them to maintain them better >? Any ideas would be greatly appreciated. Thank You in advance.

Re: LARGE databases

PostPosted: Thu Sep 27, 2012 10:05 am
by mcargile
PHP has an execution time limit in it. This is to prevent runaway code from crashing web servers. It however also means that any PHP script that has to run for a while risks getting killed before it completes. The list download script is one such PHP script. With more than about 100,000 leads in a list you will reach the execution limit and the script will be killed. You should keep the leads in a single list below 100,000 if you plan on being able to download them in the future. You can always have multiple lists on a single campaign so this limitation will not prevent you from having that many leads on the campaign.

If you need to get the leads out of that list, you will need to use MySQL or phpMyAdmin to directly export the lead data from the database.

Re: LARGE databases

PostPosted: Thu Sep 27, 2012 10:48 am
by porpoise3
Thank You for that information. I appreciate the "heads up".