Allow ListID to be alphanumeric??

Discussions about development of VICIDIAL and astGUIclient

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

Allow ListID to be alphanumeric??

Postby kchung » Wed Sep 27, 2006 4:24 pm

Is there a reason why List IDs have to be numbers only?

I upload leads from different sources for different campaigns daily.

What I would like to do is upload lists w/ 2-3 letter prefix to denote type of leads followed by the date ie: INS20060927 = insurance leads for Sept 27, 2006.

Is it safe for me to edit my code to allow for chars in the Lead ID?
kchung
 
Posts: 208
Joined: Fri Aug 04, 2006 5:28 pm

Postby mflorell » Wed Sep 27, 2006 4:53 pm

could you use the vendor_lead_code for that type of information?

You could alter all of the tables that have lead_id in them to whatever you want and the system would run just fine.

We chose to use INT(9) AUTO-INCREMENT UNIQUE to keep the table clean and quick.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby kchung » Thu Oct 12, 2006 4:11 pm

I mean list_id, not lead_id.
kchung
 
Posts: 208
Joined: Fri Aug 04, 2006 5:28 pm

Postby mflorell » Thu Oct 12, 2006 4:57 pm

If you change all tables and the admin.php code you should be able to use alpha characters in the list_id.

We wanted to keep it numeric only so that vicidial_list would be sorted by list_id faster than if it was alpha-numeric.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby kchung » Thu Oct 12, 2006 10:09 pm

Exactly how much impact does it have?
kchung
 
Posts: 208
Joined: Fri Aug 04, 2006 5:28 pm

Postby mflorell » Fri Oct 13, 2006 6:57 am

depends on the size of your vicidial_list table. With 6 million records it is significant enough to notice the difference between BIGINT and VARCHAR(20).
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby kchung » Fri Oct 13, 2006 12:32 pm

damn, that is huge. Does your company routinely deal with 6m records? what do you'all call?!
kchung
 
Posts: 208
Joined: Fri Aug 04, 2006 5:28 pm

Postby mflorell » Sat Oct 14, 2006 9:07 pm

When we were doing a few large campaigns at once we did keep 6m records in the vicidial_list table. Now we keep it to less than 1million.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Development

Who is online

Users browsing this forum: No registered users and 30 guests