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

[Alan Lord]

Sorry list - I mistakenly replied to Matus and not the list:


> 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
> 
> I disagree. crmentitycf will just be "another join" and another huge table with potentially millions of rows.
> 
> I believe that a description column belongs in the relevant module's main table.
> 
> It should be fairly easy to find all the offending modules from vtiger_field (select * from vtiger_field where tablename = vtiger_crmentity AND uitype = 21(?)and columnname = 'description'), then get the module's main table from that module class file, then create a new TEXT column in that table, change the target table in vtiger_field and copy the data across.
> 
> 
> Al 




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
>