[Vtigercrm-developers] global search in vt7.4 takes too long in comparisson to vt6.5

[Angelo Paglialonga]

Yes and in addition to those steps , you should add indexes on fields used by all the slow queries you can find. 

_______________

Angelo Paglialonga
Consulente per soluzioni CRM ad alto ROI.

Telefono: 3386077866
Skype: angelo.paglialonga
Web: https://www.angelopaglialonga.com


> Il giorno 23 feb 2022, alle ore 17:40, Alan Lord <alanslists at gmail.com> ha scritto:
> 
> 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?
> 
> A few things I would do:
> 
> * Enable the slow query log.
> 
> * Capture the exact query and then EXPLAIN it.
> 
> * Check the processlist.
> 
> HTH
> 
> Al
> 
> 
>> On 23/02/2022 16:31, Rubén A. Estrada Orozco wrote:
>> Hi everyone,
>> I recently migrated a client from vt65 to vt7.4.
>> 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.
>> When doing a global search in vtiger 7.4 it takes about 1 minute:
>> image.png
>> image.png
>>  The exact same search takes 2 seconds in vt6.5:
>> image.png
>> image.png
>> Why this huge difference?
>> Saludos
>> Rubén
>> _______________________________________________
>> http://www.vtiger.com/
> 
> 
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220223/3da5cc70/attachment.html>