segregating active list and inactive list on different table

[Op3r]

I got this idea when having a difficult client that wants to load leads during operation.

I think having a table where all the inactive leads goes to will make the vicidial_list less problematic when loading leads but the drawback will make it more fragmented. is there such a thing as fragmentation of table on mysql?

[mflorell]

There would be a lot of issues with doing this, not least of which is the auto-increment on the lead_id. Everything would still have to get a system-assigned auto-increment ID somewhere, and we still need a way to create new leads for inbound calls.