[Vtigercrm-developers] performance turning tips : listview search

Alan Bell alan.bell at libertus.co.uk
Fri Sep 25 14:23:21 GMT 2015


you need to turn on and look at your database slow query log and log all 
queries not using indexes. If you are seeing unindexed queries then you 
need to index the relevant columns, this involves lots of putting the 
queries into the mysql console or PHPmyadmin and doing an "explain 
select" and interpretting the results you get back, then you add indexes 
or tweak the code to do more efficient joins and use the indexes more 
often. You can also use xdebug to profile the code that vtiger runs, in 
that you will find that the to_html function is the most called function 
that takes the most time, so you can improve that by adding a cache, 
and/or other tests that speed that process up.

Alan.

On 25/09/15 15:17, lajeesh k wrote:
> 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/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150925/fc8c1054/attachment.html>


More information about the vtigercrm-developers mailing list