Toto
Joined: 18 Jul 2006
Posts: 39
|
| Posted: Thu Jul 27, 2006 10:22 pm Post subject: vtiger_activitytype table not working hard enough? |
|
|
I noticed today that in V5beta2 the table vtiger_activity uses a varchar(50) to record the "activitytype" field, while there is a table vtiger_activitytype with an int(19) field "activitytypeid".
Wouldn't it be better to change vtiger_activity.activitytype to an int, to save space and time on comparissons, and refer back to the vtiger_activitytype when you require the name? The table already exists. It seems like it's not doing much, really.
Toto |
|