[Vtigercrm-developers] vtiger slowing down (a lot)

[Alan Lord]

Also take your query (you'll need to replicate creating the temp table) 
and EXPLAIN it. There may be some indexes that could be added that would 
help speed things up a lot.

Al


On 28/09/2022 20:29, Rubén A. Estrada Orozco wrote:
> Hi everyone,
> 
> In cases where a  vtiger database gets big over time, queries start to 
> take longer and longer. In some cases the database gets big because of 
> junk records. In those cases one might want to delete those records to 
> improve performance.
> In a recent case I noticed that a query for loading the detail view of 
> the Leads module was taking aprox 10 seconds with ~409k records. Here is 
> what I got from the slow query log (Note that the rows being examined is 
> ~3.6 million):
>