search

Adyen / adyen-magento2

Adyen Payment plugin for Magento2
MIT License
150 stars 196 forks source link

Improvement Suggestion: Add index to merchant_reference column in adyen_payment_response #2608

Closed furan917 closed 1 month ago

furan917 commented 2 months ago

If possible I'd like the team to do an quick additional optimization pass on the db_schema.xml file to add DB indexes to tables where queries are ran against.

Specifically one of my clients is seeing increased performance loss on any pathway searching on the merchant_reference which is causing 2-4s additional load time.

Describe the solution you'd like A quick addition of an index to adyen_payment_response on merchant_reference

Additional context This is not a big problem, but a nice to have, especially as we can manually add a reference ourselves. 

CREATE INDEX ADYEN_PAYMENT_RESPONSE_MERCHANT_REFERENCE ON adyen_payment_response (merchant_reference);
RokPopov commented 1 month ago

Hi @furan917, thank you for raising this with us.

We currently have an investigation ticket opened for looking into the necessity of the adyen_payment_response table alltogether. You can follow the progress of the issue related to the investigation here.

I will be closing the ticket for now.

Kind regards, Rok