LARGE databases

All installation and configuration problems and questions

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

LARGE databases

Postby noworldorder » Thu Feb 02, 2012 3:14 am

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?
http://www.scrubmydata.com Your First Scrub is FREE
Vicibox 4.0 | VERSION: 2.6-375a BUILD: 120831-1523
Realtek RTL8111/8168B PCI Dual Core 2 GB Ram
no other software read the manual
GRATEFUL FOR VICIDIAL!
noworldorder
 
Posts: 391
Joined: Sat Mar 06, 2010 3:56 pm

Postby sobek » Thu Feb 02, 2012 5:38 am

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.
sobek
 
Posts: 11
Joined: Tue Jun 08, 2010 1:33 pm

Postby mflorell » Thu Feb 02, 2012 9:38 pm

As long as your system is properly configured you can have millions of leads in a single list if your hardware supports it.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: LARGE databases

Postby williamconley » Thu Feb 02, 2012 10:21 pm

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

Postby noworldorder » Thu Feb 02, 2012 11:37 pm

[quotey ]WHO told you that? [/quote]

My IT... but we all make mistakes
Last edited by noworldorder on Thu Sep 27, 2012 11:11 am, edited 1 time in total.
http://www.scrubmydata.com Your First Scrub is FREE
Vicibox 4.0 | VERSION: 2.6-375a BUILD: 120831-1523
Realtek RTL8111/8168B PCI Dual Core 2 GB Ram
no other software read the manual
GRATEFUL FOR VICIDIAL!
noworldorder
 
Posts: 391
Joined: Sat Mar 06, 2010 3:56 pm

Re: LARGE databases

Postby porpoise3 » Thu Sep 27, 2012 9:56 am

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.
porpoise3
 
Posts: 34
Joined: Fri Feb 12, 2010 12:55 pm
Location: West Florida

Re: LARGE databases

Postby mcargile » Thu Sep 27, 2012 10:05 am

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.
Michael Cargile | Director of Engineering | ViciDialGroup | http://www.vicidial.com

The official source for VICIDIAL services and support. 1-888-894-VICI (8424)
mcargile
Site Admin
 
Posts: 617
Joined: Tue Jan 16, 2007 9:38 am

Re: LARGE databases

Postby porpoise3 » Thu Sep 27, 2012 10:48 am

Thank You for that information. I appreciate the "heads up".
porpoise3
 
Posts: 34
Joined: Fri Feb 12, 2010 12:55 pm
Location: West Florida


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 74 guests