[Vtigercrm-developers] Report records count error

[Alan Lord]

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