Page 1 of 1

segregating active list and inactive list on different table

PostPosted: Wed Apr 14, 2010 1:48 am
by 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?

PostPosted: Wed Apr 14, 2010 2:16 am
by 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.