I would start by enabling MySQL slow query logs (or similar), then once you find some culprits, make sure that you have indexes corresponding to your WHERE clauses.<div class="gmail_extra"><br><br><div class="gmail_quote">
On Tue, Nov 27, 2012 at 6:09 AM, Richard Hills - TechnologyWise <span dir="ltr"><<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I have a module which has a few million rows of entities, I have found<br>
the performance of the related list to be rediculously slow, however<br>
this is a custom module (I have no modules with relative data sizes to<br>
compare unfortunately, this will be my next step if nobody here has any<br>
input).<br>
<br>
I was wondering if anyone else has this issue with the related lists<br>
loading slowly, or if this is just down to an issue I have with my<br>
customisation.<br>
<br>
Thanks<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div>