[Vtigercrm-developers] slow vtiger server

[Rubén A. Estrada Orozco]

Alan, thanks for the advice.

I did look into the indexes for the query. I'm no expert on this, but to me
it looks fine:

[image: image.png]

[image: image.png]

all tables are using an index. I even tried creating new indexes, but mysql
kept using PRIMARY.



Saludos

Rubén


On Tue, Aug 4, 2020 at 5:44 AM Alan Lord <alanslists at gmail.com> wrote:

> On 03/08/2020 20:01, Rubén A. Estrada Orozco wrote:
> >
> > Alan Lord, you previously commented that you have clientes with huge
> > databases (several million rows). It would be really helpful to get some
> > advice from you.
> >
>
> Also check out the recent commit I made for this issue:
> https://code.vtiger.com/vtiger/vtigercrm/issues/1016
>
> It make a huge performance improvement for comment retrieval under
> particular circumstances...
>
> ~1 minute to load comments without patch and less than 200 milli-seconds
> with my patch :-)
>
> Al
>
>
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200804/caf95099/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 47699 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200804/caf95099/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 24375 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200804/caf95099/attachment-0003.png>