Thank you Alan, for sharing the details on the performance difference.<div><br></div><div>Regards,</div><div>Prasad<br><br><div class="gmail_quote">On Mon, Mar 11, 2013 at 9:46 PM, Alan Lord <span dir="ltr"><<a 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">On 06/03/13 16:09, Alan Lord wrote:<br>
><br>
> One particluar module, lets call it "A", has rather a lot of fields in<br>
> various blocks (~94). By way of a comparison it takes ~2.5 seconds to<br>
> load a detailview for module "A" whereas for an Account or Contact it<br>
> takes about 0.5 seconds...<br>
<br>
Prasad very kindly took a look at this for us as he was rather<br>
interested in what the issue was.<br>
<br>
He suggested we look at changing some of the picklists (the customer's<br>
module has grown to have ~50 picklist fields!) from UIType 15<br>
(role-based) to UIType 16 (non-role-based).<br>
<br>
This change requires the addition of a `sortorderid` column and<br>
associated values to the related table(s) that hold the picklist values<br>
as well as the obvious changes to vtiger_field.<br>
<br>
Here are the results of changing 45 of the picklists from 15 to 16 in<br>
seconds according to Google Chrome:<br>
<br>
Load module "A" Detail View (UIType 15) - 6.28, 5.35, 5.75<br>
Load module "A" Detail View (UIType 16) - 2.03, 2.08, 2.00<br>
<br>
Load module "A" Edit View (UIType 15) - 11.69, 11.04, 11.57<br>
Load module "A" Edit View (UIType 16) - 3.31, 3.18, 3.20<br>
<br>
These tests were done on my laptop (which is not a fast machine). On our<br>
development server, the Edit View page load is down to less than one<br>
second where it was around 4 - 5 before.<br>
<br>
Thanks for the suggestion Prasad. That has made a big difference :-)<br>
<br>
Al<br>
<br>
--<br>
Libertus Solutions<br>
<a href="http://www.libertus.co.uk" target="_blank">http://www.libertus.co.uk</a><br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div>