<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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.<br>
<br>
Alan.<br>
<br>
<div class="moz-cite-prefix">On 25/09/15 15:17, lajeesh k wrote:<br>
</div>
<blockquote
cite="mid:CAA1bLmoO+nSiVioW964P_2Vu4uty4f1ki7MyFj7AL5bc=WBgWw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Hi <br>
<br>
</div>
<div>I have more than a million records<br>
</div>
can I get performance turning tips for faster listview
search<br>
</div>
need this mainly in leads<br>
</div>
tuning like settings foreign keys<br>
<br>
<br clear="all">
<div>
<div>
<div>
<div>
<div>
<div class="gmail_signature"><br>
Regards,<br>
Lajeesh<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>