I have a site that accepts credit card payments. The order number is generated, saved to the database, and gets sent to the payment gateway.
In the event of a failed payment (invalid credit card number, etc), should the order number be retained, or must it be deleted and reused?
Any feedback will be appreciated.