-
Notifications
You must be signed in to change notification settings - Fork 12
Description
Improvement suggestion
Hi,
I noticed that this plugin generates new meta_key names for every order (_checkout_reference_XXXXX) in addition to the global key _checkout_reference. It is generated in \Paytrail\WooCommercePaymentGateway\Gateway::process_payment, line 939.
I would consider this as bloat and would like to use only the _checkout_reference meta_key instead. It also affects to the database performance, since it is the only key which changes for every order and the same value is also stored to _checkout_reference.
Describe the solution you'd like
Would it be possible to disable the _checkout_reference_XXXXX metas with a filter? If it is disabled, the search could be done from the _checkout_reference value.
Describe alternatives you've considered
Are the _checkout_reference_x keys really needed at all? Or are reference key searches in some environment really slow without it? If the searches with the general _checkout_reference key aren't currently too slow the _checkout_reference_x keys could be dropped altogether?
Additional context
We are using an analytics service (Metorik), which allows to filter and segment order statistics by the meta keys and now it is full of _checkout_reference_xxxxx keys. It seems that Klarna's, Stripe's and other Paytrail plugins don't add extra key names for each order like this.