<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">caching it would be bad, but making
sure that all queries involved use the mysql indexes would be
good. If you turn on the slow query log and log unindexed queries
in the my.cnf file then monitor /var/log/mysql/mysql-slow.log you
will see all the unindexed queries it does. If you go through each
one and optimise the query by creating suitable indexes until
there are basically none left (apart from the full text search,
which you get rid of by using the sphinx search plugin) then
vtiger is a lot lot faster and queries like this would have no
significant cost to them because they are basically precomputed in
the mysql server.<br>
<br>
Alan.<br>
<br>
On 16/05/13 12:24, socialboostdk wrote:<br>
</div>
<blockquote
cite="mid:CACQ7aj9vWotNGWMR0V6Eng5q54kMyL2pEVPocJZxCs8rn07cjA@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Appu,
<div><br>
</div>
<div>Thanks for always answering the emails here on the list.</div>
<div><br>
</div>
<div style="">While the answer might seem obvious, I still would
want to pitch in: </div>
<div style=""><br>
</div>
<div style="">It would just be a simple matter of having the
results (ie. number of documents, emails, products, etc)
cached, so it only is updated when ever the number of
documents, emails, products etc., are changed - which is
probably only rarely.</div>
<div style=""><br>
</div>
<div style="">If you're interested, we can pitch in with a
possible patch for this?</div>
<div style=""><br>
</div>
<div style="">:) Christian</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
On 16 May 2013 12:35, Appu <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:apparao@vtiger.com"
target="_blank">apparao@vtiger.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><font color="#000000"><font
face="verdana,sans-serif">Alan,</font></font>
<div><font color="#000000"><font face="verdana,sans-serif"><br>
</font></font></div>
<div><font color="#000000"><font face="verdana,sans-serif">Thanks
for the feedback. We plan to show some indication on
the related tabs to the right to help users identify
the tabs that have records. As you suspected, the
reason it is not done yet, is because of the
additional db traffic it will impose. We plan to
take this up after some performance tuning is done.</font></font></div>
<div><font color="#000000"><font face="verdana,sans-serif"><br>
</font></font></div>
<div>
<div>
<div dir="ltr"><span
style="color:rgb(102,102,102);font-family:verdana,sans-serif"><span
style="font-family:verdana,sans-serif">Regards,</span></span><br
style="font-family:verdana,sans-serif">
<font style=""><span
style="font-family:verdana,sans-serif">Apparao G</span></font><br>
<br style="font-family:verdana,sans-serif">
<b style="color:rgb(51,51,51)"><font
style="font-family:verdana,sans-serif;color:rgb(102,102,102)"><img
moz-do-not-send="true" height="24" width="96"><font
size="1">TEAM</font></font></b><br>
<br>
<b style="font-family:verdana,sans-serif">Connect
with us on: </b><a moz-do-not-send="true"
style="font-family:verdana,sans-serif"
href="http://vtiger.com/" target="_blank">Website</a><b
style="font-family:verdana,sans-serif"> </b><b
style="font-family:verdana,sans-serif">I</b><span
style="font-family:verdana,sans-serif"> </span><a
moz-do-not-send="true"
style="font-family:verdana,sans-serif"
href="http://twitter.com/#%21/vtigercrm"
target="_blank">Twitter</a><span
style="font-family:verdana,sans-serif"> </span><b
style="font-family:verdana,sans-serif">I</b><span
style="font-family:verdana,sans-serif"> </span><a
moz-do-not-send="true"
style="font-family:verdana,sans-serif"
href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall"
target="_blank">Facebook</a><span
style="font-family:verdana,sans-serif"> </span><b
style="font-family:verdana,sans-serif">I</b><span
style="font-family:verdana,sans-serif"> </span><a
moz-do-not-send="true"
style="font-family:verdana,sans-serif"
href="http://blog.vtiger.com/" target="_blank">Blog</a><b
style="font-family:verdana,sans-serif"> I</b><span
style="font-family:verdana,sans-serif"> </span><a
moz-do-not-send="true"
style="font-family:verdana,sans-serif"
href="http://wiki.vtiger.com/index.php/Main_Page"
target="_blank">Wiki</a><span
style="font-family:verdana,sans-serif"> </span><b
style="font-family:verdana,sans-serif">I </b><a
moz-do-not-send="true"
style="font-family:verdana,sans-serif"
href="http://forums.vtiger.com/" target="_blank">Forums </a><span
style="font-family:verdana,sans-serif"> </span><br>
<span style="color:rgb(102,102,102)"><span></span><b><span></span></b></span></div>
</div>
<div>
<div class="h5">
<br>
<br>
<div class="gmail_quote">On Thu, May 16, 2013 at
2:42 PM, Alan Lord <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:alanslists@gmail.com"
target="_blank">alanslists@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0
0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
Hi Guys,<br>
<br>
further to the recent update there's one more
thing I've seen in vtiger 6 that I think needs
to be addressed...<br>
<br>
Almost all of our customers today enable single
pane view.<br>
<br>
With the new Summary view and Details view there
is no way to get a single page showing
everything. The tabs on the right hand side
linking to the various related entities *really*
need to indicate to the user there are related
entities or not.<br>
<br>
I think that ideally there should be a number
next to those items that have related records,
e.g.<br>
<br>
Comments (2)<br>
Emails (6)<br>
Documents<br>
Products (1)<br>
<br>
Alternatively, if taking a count is going to be
excessive on db traffic, perhaps the tab name
simply gets highlighted in some way to indicate
there are records and not if there are none.<br>
<br>
As it stands now, as a user we have no way of
knowing if there are related records without
having to manually click and go into the various
tabs which is going to be a PITA.<br>
<br>
Cheers<br>
<br>
Al<br>
<br>
_______________________________________________<br>
<a moz-do-not-send="true"
href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
<a moz-do-not-send="true" href="http://www.vtiger.com/"
target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</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>
<br>
<pre class="moz-signature" cols="72">--
Libertus Solutions
<a class="moz-txt-link-freetext" href="http://libertus.co.uk">http://libertus.co.uk</a></pre>
</body>
</html>