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

[Alan Lord]

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/