[Vtigercrm-developers] performance turning tips : listview search

[lajeesh k]

Thank you so much Alan for spending your time for writing these long mails,

your suggestion is awesome, after removing wildcard from the start I got
huge performance improvement.
query time decreased from 34 seconds to 0.08 seconds.

also your tips for list.js also really helped me.






Regards,
Lajeesh

On Fri, Sep 25, 2015 at 9:42 PM, Alan Bell <alan.bell at libertus.co.uk> wrote:

> finally, if you want your list views to be "starts with" queries rather
> than "contains" queries you can edit
> layouts/vlayout/modules/Vtiger/resources/List.js  around line 1893
> and change from:
>             var searchOperator = 'c';
> to:
>             var searchOperator = 's';
>
> then it will use any indexes you have on those columns. This should
> probably be a configurable preference in the config.inc.php or something.
>
> Alan.
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150926/76a15ab2/attachment.html>