[Vtigercrm-developers] Descriptions fields are shorter in Vtiger 7.3

[Alan Lord]

And again:

>> Yes and NO.
>>
>> The join will be only in when you need to use descriptions like Emails, Sumary views, ...?
>> If you put description into relevant module's main table, then all listviews will search records from hudge table ?
> 
> Each modules' table will only ever be as big (long) as the number of records in *that* module... having it in crmentity(cf) means the table is as large as *EVERY* record. i.e. millions.
> 
> I'm not sure which approach is "better" tbh. Having a mediumtext[1] column in the main table makes no sense to me. Whether it is better for performance (crmentitycf) or overall database size (relevant modules' table) would probably need testing.
> 
> Cheers
> 
> Al
> 
> [] MEDIUMTEXT is a string data type with a maximum length of 16,777,215 characters.



On 28/10/2020 09:17, Ing. Matus Sopko wrote:
> Yes this can be another point for Vtiger 7.4.
> Because of better performance.
> Table: vtiger_crmentitycf ;-)
> and column vtiger_crmentitycf.description
> 
> S pozdravom / Best regards / Mit freundlichen Grüßen
> Ing. Matus SOPKO
>