10 million leads

All installation and configuration problems and questions

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

10 million leads

Postby TwistedFister » Thu Feb 08, 2018 3:14 pm

Vicibox 7.0.3 from .iso | Vicidial 2.14-579a Build 161128-1746 | Asterisk 11.22.0-vici | CLuster setup: 1 web 1 DB 1 Slave DB 8 telephony | No Digium/Sangoma Hardware | No Extra Software After Installation

We have accumulated over 10 million leads in the last year and its really having an impact on overall performance. We use the lead up to 3 months to where we pull a particular criteria from the database and recall them. Reading through many forum posts about deleting leads gave me insight as to how i should approach this but i want to check to see if there is a better way.


Code: Select all
delete from vicidial_list where entry_list_id between xxx and yyyy

select count(*), list_id from vicidial_list GROUP BY list_id

DELETE * from vicidial_list v where entry_list_id = xxx AND v.entry_date < '2017-11-24 05:55:31'


The goal is reduce lag and system load, reduce the amount of visible lists to select from when importing new leads, maintaining callbacks, and preserving call data for that lead. Will this work? What is the norm?
TwistedFister
 
Posts: 78
Joined: Tue Jul 26, 2016 11:50 am

Re: 10 million leads

Postby blackbird2306 » Thu Feb 08, 2018 5:33 pm

look here how to archive the leads rather than to delete:
http://vicidial.org/VICIDIALforum/viewtopic.php?f=4&t=37451
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm


Return to Support

Who is online

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