search

mollie / magento2

Mollie Payments for Magento 2
https://www.mollie.com
Other
98 stars 50 forks source link

Adding index to db table mollie_payment_transaction_to_order - improving performance #624

Closed dpotkoc closed 1 year ago

dpotkoc commented 1 year ago

In version 2.22.0 you have logic for load by transaction_id from db table: mollie_payment_transaction_to_order.

https://github.com/mollie/magento2/blob/7553c8a9bd7ec4a4302449c026aa9145f4731fc3/etc/db_schema.xml#L115

It will be good if you can add index for column: transaction_id.

Frank-Magmodules commented 1 year ago

Hi There @dpotkoc , I've talked with the development team on this and indeed that could be a good idea!
We have added it to our feature request roadmap, I will update you once I have a sight on the ETA.

Frank-Magmodules commented 1 year ago

Hello @dpotkoc ,

We're pleased to inform you that the latest version of the Mollie plugin now includes the feature you requested. We hope this solution meets your requirements. For now, we will mark this issue as resolved. However, if you require further assistance, please feel free to reopen the issue.