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

[Alan Lord]

 > I wrote:
> I would have expected this to read:
> 
>> Extra: Using where; Using index; Using temporary; Using filesort
> 
> (Note the "using index;").
> 
> are you missing an index/Primary Key on either vtiger_invoice or vtiger_invoicecf? 

Please ignore this bit above.

I was reading this page and it discusses when and how MySQL determines 
if it should use an index or not.

https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html

I checked again by including some valid columns of my own in the 
invoicecf table. Now it doesn't use an index.


Sorry for the noise.

Al