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

[Home Plus]

How can I be removed from future conversations? Thanks

Sent from my iPhone

> On Oct 2, 2022, at 7:17 AM, Alan Lord <alanslists at gmail.com> wrote:
> 
> > 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
> 
> _______________________________________________
> http://www.vtiger.com/