[Vtigercrm-developers] count(*) speed in related list

[Adam Heinz]

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.


On Tue, Nov 27, 2012 at 6:09 AM, Richard Hills - TechnologyWise <
richard at tw.co.nz> wrote:

> I have a module which has a few million rows of entities, I have found
> the performance of the related list to be rediculously slow, however
> this is a custom module (I have no modules with relative data sizes to
> compare unfortunately, this will be my next step if nobody here has any
> input).
>
> I was wondering if anyone else has this issue with the related lists
> loading slowly, or if this is just down to an issue I have with my
> customisation.
>
> Thanks
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20121127/4db58c87/attachment.html