Performance issue on setDefaultPaymentMethod

Skip to first unread message

Lucas Luz

Aug 31, 2021, 5:52:12 PMAug 31
to Kill Bill users mailing-list
Hi guys,

We are having performance issue with a query update. Basically the problem is related to this method: 
I believe the problem may be related to the not equals operator. We have in the adyen_payment_methods table a quantity of 1.963.045 records.
Running a cost analysis of the query, we noticed that the cost was 1000.00 - 132899.71 and the method response time was 26 seconds.

Thanks a lot in advance
Reply all
Reply to author
0 new messages