10 million leads
Posted: Thu Feb 08, 2018 3:14 pmVicibox 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.
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?
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?