[Vtigercrm-developers] performance turning tips : detailview

[lajeesh k]

I have used Alan's tips on my another thread

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.






Regards,
Lajeesh

On Fri, Oct 2, 2015 at 7:36 PM, Simone Travaglini <
simonetravaglini at gmail.com> wrote:

> hi colud you share finally how you optimised listview?
>
> 2015-10-02 15:45 GMT+02:00 lajeesh k <lajeeshk at gmail.com>:
>
>> Hi,
>> I have  more than a million records
>> i have optimised listview search and data import
>>
>> Now I have slow down in detailview page
>> Any tips to optimise detailview ?
>>
>>
>> Regards,
>> Lajeesh
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
>
> --
> Simone Travaglini
> 328 5499846
> Linkedin: Simone Travaglini
>
>
> Rispetta l'ambiente: non stampare questa mail se non ti è veramente
> necessario!
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20151002/e70523b7/attachment.html>