[Vtigercrm-developers] Report records count error

Alan Lord alanslists at gmail.com
Fri Feb 12 08:31:51 GMT 2021

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.



More information about the vtigercrm-developers mailing list