<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body 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 class="ApplePlainTextBody" style="font-family: Helvetica; font-size: 14px; -webkit-text-size-adjust: auto;">_______________<br><br>Angelo Paglialonga<br>Consulente per soluzioni CRM ad alto ROI.<br><br>Telefono: 3386077866<br>Skype: angelo.paglialonga<br>Web: https://www.angelopaglialonga.com</div><div class="ApplePlainTextBody" style="font-family: Helvetica; font-size: 14px; -webkit-text-size-adjust: auto;"><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 <alanslists@gmail.com> 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>_______________________________________________</span><br></blockquote><blockquote type="cite"><span>http://www.vtiger.com/</span><br></blockquote><span></span><br><span></span><br><span>_______________________________________________</span><br><span>http://www.vtiger.com/</span></div></blockquote></body></html>