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

[Alexander Allen]

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.

El miércoles, 23 de febrero de 2022, Angelo Paglialonga <
info at angelopaglialonga.com> escribió:

> 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/d1977537/attachment.html>