I&#39;m not interested to work, discuss... with any abonline members (company i have funded in 2005).<br>I have a tons of improvements for vtigerCRM (and large customers like Dexia, leboncoin.fr...), so i can exchange with vtiger team, you joe and lot of other community members.<br>
Regards,<br><br>-- <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><br><div class="gmail_quote">2010/12/8 Joe Bordes <span dir="ltr">&lt;<a href="mailto:joe@tsolucio.com">joe@tsolucio.com</a>&gt;</span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">


  
    
  
  <div text="#000000" bgcolor="#ffffff">
    Hi,<br>
    <br>
    These are very important optimizations. Thank you.<br>
    You should get together with Boris Clement on the optimizations
    project:<br>
    <a href="http://forge.vtiger.com/projects/vtsql-opt/" target="_blank">http://forge.vtiger.com/projects/vtsql-opt/</a><br>
    <br>
    Thanks<br>
    Joe<br>
    TSolucio<br>
    <br>
    El 08/12/10 15:27, Aissa belaid escribió:
    <blockquote type="cite"><div><div></div><div class="h5">idem with this column : <span>vtiger_troubletickets.</span><span>product_id and </span><span>vtiger_troubletickets.</span><span>parent_id</span><br>
      <br>
      <span><span style="color:rgb(255, 164, 149)"><b>ALTER</b></span>
        <span style="color:rgb(255, 164, 149)"><b>TABLE</b></span>
        `vtiger_troubletickets` CHANGE `product_id` `product_id` INT( 19
        ) NULL DEFAULT NULL; <br>
        <br>
        <span style="color:rgb(255, 164, 149)"><b>ALTER</b></span> <span style="color:rgb(255, 164, 149)"><b>TABLE</b></span>
        `vtiger_troubletickets` CHANGE `parent_id` `parent_id` INT( 19 )
        NULL DEFAULT NULL;
      </span><br>
      <br>
      <div class="gmail_quote">2010/12/8 Aissa belaid <span dir="ltr">&lt;<a href="mailto:aissabelaid@gmail.com" target="_blank">aissabelaid@gmail.com</a>&gt;</span><br>
        <blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
          I have no access for vtiger trac<br>
          <br>
          <div class="gmail_quote">
            <div>
              <div>2010/12/8 David V. <span dir="ltr">&lt;<a href="http://davidv.net" target="_blank">davidv.net</a>@<a href="http://gmail.com" target="_blank">gmail.com</a>&gt;</span><br>
              </div>
            </div>
            <blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
              <div>
                <div>
                  Thank you for pointing this out.
                  <div><br>
                  </div>
                  <div>Maybe you could also report it in Trac.</div>
                  <div><br clear="all">
                    David V.<br>
                    <br>
                    <br>
                    <div class="gmail_quote">
                      <div>
                        <div>2010/12/8 Aissa belaid <span dir="ltr">&lt;<a href="mailto:aissabelaid@gmail.com" target="_blank">aissabelaid@gmail.com</a>&gt;</span><br>
                        </div>
                      </div>
                      <blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
                        <div>
                          <div>
                            Hi David,<br>
                            because you have a join between integer col
                            &amp; varchar col in the sql query.<br>
                            With 100 line, no problem ;-) <br>
                            With 100 000 you can wait 2h.<br>
                            <br>
                            Exemple query for contacts :<br>
                            <br>
                            <br>
                            select vtiger_contactdetails.contactid as
                            recordid,vtiger_users_last_import.deleted,$table_cols
                            <br>
                                                FROM
                            vtiger_contactdetails<br>
                                                INNER JOIN
                            vtiger_crmentity ON
                            vtiger_crmentity.crmid=vtiger_contactdetails.contactid<br>
                                                INNER JOIN
                            vtiger_contactaddress ON
                            vtiger_contactdetails.contactid =
                            vtiger_contactaddress.contactaddressid<br>
                                                INNER JOIN
                            vtiger_contactsubdetails ON
                            vtiger_contactaddress.contactaddressid =
                            vtiger_contactsubdetails.contactsubscriptionid<br>
                                                LEFT JOIN
                            vtiger_contactscf ON
                            vtiger_contactscf.contactid =
                            vtiger_contactdetails.contactid <br>
                                               <b> LEFT JOIN
                              vtiger_users_last_import ON
                              vtiger_users_last_import.bean_id=vtiger_contactdetails.contactid*</b><br>
                                                LEFT JOIN vtiger_account
                            ON
                            vtiger_account.accountid=vtiger_contactdetails.accountid<br>
                                                LEFT JOIN
                            vtiger_customerdetails ON
                            vtiger_customerdetails.customerid=vtiger_contactdetails.contactid<br>
                                                LEFT JOIN vtiger_groups
                            ON vtiger_groups.groupid =
                            vtiger_crmentity.smownerid<br>
                                                LEFT JOIN vtiger_users
                            ON <a href="http://vtiger_users.id" target="_blank">vtiger_users.id</a> =
                            vtiger_crmentity.smownerid<br>
                                                INNER JOIN (select
                            $select_clause from vtiger_contactdetails t<br>
                                                        INNER JOIN
                            vtiger_crmentity crm ON
                            crm.crmid=t.contactid<br>
                                                        INNER JOIN
                            vtiger_contactaddress addr ON t.contactid =
                            addr.contactaddressid<br>
                                                        INNER JOIN
                            vtiger_contactsubdetails subd ON
                            addr.contactaddressid =
                            subd.contactsubscriptionid<br>
                                                        LEFT JOIN
                            vtiger_contactscf tcf ON t.contactid =
                            tcf.contactid <br>
                                                        LEFT JOIN
                            vtiger_account acc ON
                            acc.accountid=t.accountid<br>
                                                        LEFT JOIN
                            vtiger_customerdetails custd ON
                            custd.customerid=t.contactid<br>
                                                        WHERE
                            crm.deleted=0 group by $select_clause 
                            HAVING COUNT(*)&gt;1) as temp<br>
                                                    ON
                            &quot;.get_on_clause($field_values,$ui_type_arr,$module).&quot;<br>
                                                WHERE
                            vtiger_crmentity.deleted=0 $sec_parameter
                            ORDER BY
                            $table_cols,vtiger_contactdetails.contactid
                            ASC<br>
                            <br>
                            *Here uou kill the perfs. Contactid is an
                            INT type, and bean_id a varchar.<br>
                            You don&#39;t need this patch for small
                            database.<br>
                            <br>
                            <br>
                            <div class="gmail_quote">2010/12/8 David V.
                              <span dir="ltr">&lt;<a href="http://davidv.net" target="_blank">davidv.net</a>@<a href="http://gmail.com" target="_blank">gmail.com</a>&gt;</span><br>
                              <blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
                                <div>
                                  <div>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">&lt;<a href="mailto:aissabelaid@gmail.com" target="_blank">aissabelaid@gmail.com</a>&gt;</span><br>
                                        <blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
                                          <div>
                                            <div>
                                              Hi team,<br>
                                              there is a problem with
                                              database schema for
                                              duplicate handling &amp;
                                              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>
                                            </div>
                                          </div>
_______________________________________________<br>
                                          <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
                                        </blockquote>
                                      </div>
                                      <br>
                                    </div>
                                    <br>
                                  </div>
                                </div>
_______________________________________________<br>
                                <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
                              </blockquote>
                            </div>
                            <br>
                            <br>
                          </div>
                        </div>
                        _______________________________________________<br>
                        <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
                      </blockquote>
                    </div>
                    <br>
                  </div>
                  <br>
                </div>
              </div>
              _______________________________________________<br>
              <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
            </blockquote>
          </div>
          <div>
            <div><br>
              <br clear="all">
              <br>
              -- <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>
            </div>
          </div>
        </blockquote>
      </div>
      <br>
      <br clear="all">
      <br>
      -- <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>
      </div></div><pre><fieldset></fieldset>
_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
    </blockquote>
    <br>
  </div>

<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br>