[Vtigercrm-developers] performance turning tips : listview search

[Simone Travaglini]

Hi, I've same problem with a customer with 1,8 million of lead listview
need 10-15 sec. to load in a VPS with 4 gb ram an 1 core. I looked at top
command and see that ram used is <2GB but processor is totally used.
Obviously the process that use all re, sources is mysqld


2015-09-25 16:17 GMT+02:00 lajeesh k <lajeeshk at gmail.com>:

> Hi
>
> I have  more than a million records
> can I get performance turning tips for faster listview search
> need this mainly in leads
> tuning like settings foreign keys
>
>
>
> 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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150925/ad53c6fe/attachment.html>