[Vtigercrm-developers] description field in vtiger_crmentity

[Joe Bordes]

Sounds good
+1

This should be on a ticket so it doesn't get buried here (we can bury it 
in trac :-) )


On 27/01/14 13:25, Alan Bell wrote:
> Hi all,
>
> We have a customer with quite a lot of emails in their system, about 
> 1700 of them have hit the 65535 length limit of the TEXT datatype of 
> the description field in crmentity. These are mostly back and forth 
> threads with lots of over use of reply with history and some are full 
> of microsoft office formatting markup.
> It strikes me that the central crmentity table is about the last place 
> that the body of emails should be stored, I would expect that the fact 
> that this key table grows to gigabytes in size would cause performance 
> issues and this data would be better off in the vtiger_emaildetails 
> table or a completely separate table of email body fields. I am going 
> to modify the crmentity table on their instance to change that to a 
> MEDIUMTEXT which can take rather huge amounts of text if required with:
> ALTER TABLE vtiger_crmentity MODIFY description MEDIUMTEXT;
>
> however I think it would be good if that field was changed by default 
> to something bigger than TEXT and it would be good to consider not 
> having it in crmentity
>
> Alan.
>


-- 
Un saludo
Joe
TSolucio