Aïssa,<div><br></div><div>Could you explain why it improves perfs ?</div><div><br clear="all">David V.<br>
<br><br><div class="gmail_quote">2010/12/8 Aissa belaid <span dir="ltr"><<a href="mailto:aissabelaid@gmail.com">aissabelaid@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi team,<br>there is a problem with database schema for duplicate handling & import function.<br>This is a fix to improve 10x the perfs:<br>ALTER TABLE `vtiger_users_last_import` CHANGE `assigned_user_id` `assigned_user_id` INT( 19 ) NULL DEFAULT NULL ,<br>
CHANGE `bean_id` `bean_id` INT( 19 ) NULL DEFAULT NULL<br clear="all">Cheer,<br><font color="#888888">-- <br>Aïssa Bélaïd,<br>Expert CRM/BI<br>Email : <a href="mailto:aissabelaid@gmail.com" target="_blank">aissabelaid@gmail.com</a><br>
Blog : <a href="http://www.aissabelaid.fr" target="_blank">www.aissabelaid.fr</a><br>
<br>
</font><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>