[Vtigercrm-developers] Report records count error

[Henry Cumbicus Rivera]

Hello Alan,
this is the result when I do the explain to the query


Explain query: https://prnt.sc/z8mn7y

[image: image.png]



El vie, 12 feb 2021 a las 3:33, Alan Lord (<alanslists at gmail.com>) escribió:

> On 11/02/2021 22:54, Rubén A. Estrada Orozco wrote:
> > Maybe using the "EXPLAIN" mysql function to see what indexes are being
> > used, then trying to modify the query accordingly and/or add indexes to
> > your database.
>
> This is correct IMHO. Use EXPLAIN to see why the query is taking so
> long. Also you could try enabling the slow query log in mysql.
>
> You are probably missing an index somewhere.
>
> HTH
>
> Al
> _______________________________________________
> http://www.vtiger.com/



-- 

---------------------------------------------------------------
Henry C.
Tel.: 956727976
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210212/927fbdc7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 100289 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210212/927fbdc7/attachment-0001.png>