Don't sort subscriptions when creating recurring payments

pronamic / wp-pronamic-pay

The Pronamic Pay plugin allows you to easily accept payments with payment methods like credit card, iDEAL, Bancontact and Sofort through a variety of payment providers on your WordPress website.

https://pronamicpay.com

35 stars 14 forks source link

Don't sort subscriptions when creating recurring payments #224

Closed rvdsteege closed 3 years ago

rvdsteege commented 3 years ago

We're ordering query results when creating recurring payments for subscriptions:

https://github.com/pronamic/wp-pay-core/blob/3.2.0/src/Subscriptions/SubscriptionsModule.php#L1094-L1095

There's no need to sort these results and removing the ORDER BY from the SQL query improves performance.