The same thing happens to my. In related modules search. What I did was to change the search in database from %search_params% to search_params% to improve it.<br><br>El miércoles, 23 de febrero de 2022, Angelo Paglialonga <<a href="mailto:info@angelopaglialonga.com">info@angelopaglialonga.com</a>> escribió:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">Yes and in addition to those steps , you should add indexes on fields used by all the slow queries you can find. <br><br><div dir="ltr"><span style="border-collapse:separate"><div style="word-wrap:break-word"><span style="border-collapse:separate"><div style="word-wrap:break-word"><span style="border-collapse:separate"><div style="word-wrap:break-word"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><span style="border-collapse:separate"><div style="word-wrap:break-word"><span style="border-collapse:separate"><div style="word-wrap:break-word"><span style="border-collapse:separate"><div style="word-wrap:break-word"><span style="border-collapse:separate"><div style="word-wrap:break-word"><span style="border-collapse:separate"><div style="background-color:rgba(255,255,255,0);word-wrap:break-word"><div style="font-family:Helvetica;font-size:14px">_______________<br><br>Angelo Paglialonga<br>Consulente per soluzioni CRM ad alto ROI.<br><br>Telefono: 3386077866<br>Skype: angelo.paglialonga<br>Web: <a href="https://www.angelopaglialonga.com" target="_blank">https://www.<wbr>angelopaglialonga.com</a></div><div style="font-family:Helvetica;font-size:14px"><br></div></div></span></div></span></div></span></div></span></div></span></span></span></span></span></span></span></span></span></span></span></div></span></div></span></div></span></div><div dir="ltr"><br><blockquote type="cite">Il giorno 23 feb 2022, alle ore 17:40, Alan Lord <<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>> ha scritto:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><span>Weird, it's only searching the "label" column in vtiger_crmentity... If it's a newly built/migrated system does MySQL take a while to re-build its indexes I wonder?</span><br><span></span><br><span>A few things I would do:</span><br><span></span><br><span>* Enable the slow query log.</span><br><span></span><br><span>* Capture the exact query and then EXPLAIN it.</span><br><span></span><br><span>* Check the processlist.</span><br><span></span><br><span>HTH</span><br><span></span><br><span>Al</span><br><span></span><br><span></span><br><span>On 23/02/2022 16:31, Rubén A. Estrada Orozco wrote:</span><br><blockquote type="cite"><span>Hi everyone,</span><br></blockquote><blockquote type="cite"><span>I recently migrated a client from vt65 to vt7.4.</span><br></blockquote><blockquote type="cite"><span>When doing a migration, most of the time, I leave a working copy of vtiger in the original version. In this case I left a copy of vt6.5 as it was just before the migration.</span><br></blockquote><blockquote type="cite"><span>When doing a global search in vtiger 7.4 it takes about 1 minute:</span><br></blockquote><blockquote type="cite"><span>image.png</span><br></blockquote><blockquote type="cite"><span>image.png</span><br></blockquote><blockquote type="cite"><span>  The exact same search takes 2 seconds in vt6.5:</span><br></blockquote><blockquote type="cite"><span>image.png</span><br></blockquote><blockquote type="cite"><span>image.png</span><br></blockquote><blockquote type="cite"><span>Why this huge difference?</span><br></blockquote><blockquote type="cite"><span>Saludos</span><br></blockquote><blockquote type="cite"><span>Rubén</span><br></blockquote><blockquote type="cite"><span>______________________________<wbr>_________________</span><br></blockquote><blockquote type="cite"><span><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></span><br></blockquote><span></span><br><span></span><br><span>______________________________<wbr>_________________</span><br><span><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></span></div></blockquote></div></blockquote>