[Vtigercrm-developers] Vtiger 6 Usability Observation

[Alan Bell]

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.

Alan.

On 16/05/13 12:24, socialboostdk wrote:
> Hi Appu,
>
> Thanks for always answering the emails here on the list.
>
> While the answer might seem obvious, I still would want to pitch in:
>
> 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.
>
> If you're interested, we can pitch in with a possible patch for this?
>
> :) Christian
>
>
> On 16 May 2013 12:35, Appu <apparao at vtiger.com 
> <mailto:apparao at vtiger.com>> wrote:
>
>     Alan,
>
>     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.
>
>     Regards,
>     Apparao G
>
>     *TEAM*
>
>     *Connect with us on: *Website <http://vtiger.com/>***I*Twitter
>     <http://twitter.com/#%21/vtigercrm>*I*Facebook
>     <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>*I*Blog
>     <http://blog.vtiger.com/>*I*Wiki
>     <http://wiki.vtiger.com/index.php/Main_Page>*I *Forums
>     <http://forums.vtiger.com/>
>     **
>
>
>     On Thu, May 16, 2013 at 2:42 PM, Alan Lord <alanslists at gmail.com
>     <mailto:alanslists at gmail.com>> wrote:
>
>         Hi Guys,
>
>         further to the recent update there's one more thing I've seen
>         in vtiger 6 that I think needs to be addressed...
>
>         Almost all of our customers today enable single pane view.
>
>         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.
>
>         I think that ideally there should be a number next to those
>         items that have related records, e.g.
>
>         Comments (2)
>         Emails (6)
>         Documents
>         Products (1)
>
>         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.
>
>         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.
>
>         Cheers
>
>         Al
>
>         _______________________________________________
>         http://www.vtiger.com/
>
>
>
>     _______________________________________________
>     http://www.vtiger.com/
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/


-- 
Libertus Solutions
http://libertus.co.uk

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