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

Sukhdev Mohan s.mohan at myti.it
Fri Feb 25 19:15:48 GMT 2022


Also the database structure is not optimized at all. Somehow everything
works but I've had some issue that weren't amused to know that they almost
lost everything.

Il ven 25 feb 2022, 20:06 Rubén A. Estrada Orozco <rulotec1 at gmail.com> ha
scritto:

> Here's the reason for the difference guys:
> https://code.vtiger.com/vtiger/vtigercrm/issues/1688
>
> Will be doing a MR soon.
>
> Saludos
>
> Rubén
>
>
> On Wed, Feb 23, 2022 at 1:07 PM Alan Lord <alanslists at gmail.com> wrote:
>
>> On 23/02/2022 17:09, Alexander Allen wrote:
>> > 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.
>>
>> %anything% will have to ignore any indexes anyway. Is that what the
>> global search routing sends to MySQL?
>>
>> Al
>> _______________________________________________
>> http://www.vtiger.com/
>>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220225/e40f236c/attachment.html>


More information about the vtigercrm-developers mailing list