[Vtigercrm-developers] Report records count error
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