Lead/List archiving

[Acidshock]

I got a quick question because I am thinking of implementing something. Is there a reason why we dont send deactivated lists and their information to an archive table?

Seems like to me that by doing so this can provide relief to database servers that have 15+ million records in them and are under severe load when certain queries are ran.

[mflorell]

Imagine changing a list with 200,000 records to "inactive" during business hours. The vicidial_list table would freeze for a while, and nobody would be able to see lead information until it was done. Same thing for making a large list active. There shouldn't be any issue with doing this after-hours, and we have helped several clients set this up, but doing it automatically when a list is set to inactive, that would cause problems.

[williamconley]

Also imagine trying to get information from a lead who was called early yesterday but was made inactive yesterday afternoon. The record missing from the table would create a lot of challenges unless reporting, editing, etc were all modified to grab information from the archived location.

Presently we have a lot of clients who archive records that reach a specific age by pushing this information into an archive table. But this is only for Log tables (ie: old table xxxxx_log becomes xxxxx_log_archive for the old data). This is thanks to an existing script from the Vicidial Group, but applies only to log files. The impact on lead records would be quite different. After all, logs are only used for reporting ... no calls are actually generated from them. Logs are also not "editable", whereas leads are editable even if they are in lists that are inactive.

[Acidshock]

Well couldnt we just query both tables for certain reports when say an archive button is checked? Also the migration could happen in incremental amounts or after hours via a script executed in cron.

[williamconley]

Absolutely. But since you can't move the data and have it affect "one or two reports" ... these changes would have to be universal when they happen or functionality will be lost. Agents can't search for those leads from agent sessions, all reports based on vicidial_list would no longer include this information until converted ... but certainly all possible.