[Vtigercrm-developers] Performances with duplicate handling

David V. davidv.net at gmail.com
Wed Dec 8 05:36:03 PST 2010


Aïssa,

Could you explain why it improves perfs ?

David V.


2010/12/8 Aissa belaid <aissabelaid at gmail.com>

> Hi team,
> there is a problem with database schema for duplicate handling & import
> function.
> This is a fix to improve 10x the perfs:
> ALTER TABLE `vtiger_users_last_import` CHANGE `assigned_user_id`
> `assigned_user_id` INT( 19 ) NULL DEFAULT NULL ,
> CHANGE `bean_id` `bean_id` INT( 19 ) NULL DEFAULT NULL
> Cheer,
> --
> Aïssa Bélaïd,
> Expert CRM/BI
> Email : aissabelaid at gmail.com
> Blog : www.aissabelaid.fr
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20101208/0bd436c4/attachment-0002.html 


More information about the vtigercrm-developers mailing list