Title: Database keeps growing
Last modified: April 29, 2024

---

# Database keeps growing

 *  [anonwins](https://wordpress.org/support/users/anonwins/)
 * (@anonwins)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/database-keeps-growing/)
 * How to clean database of old transactions? Can I just remove old transactions
   from the database? Will that affect current user balances? Will it produce problems?
 * What is the recommended way to delete old transactions without affecting balances?
 * It would be great if the plugin had a setting for auto-deletion of old transactions
   after X days/weeks/months/years

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [anonwins](https://wordpress.org/support/users/anonwins/)
 * (@anonwins)
 * [2 years ago](https://wordpress.org/support/topic/database-keeps-growing/#post-17737207)
 * Hello?
 *  Plugin Author [Subrata Mal](https://wordpress.org/support/users/subratamal/)
 * (@subratamal)
 * [2 years ago](https://wordpress.org/support/topic/database-keeps-growing/#post-17737508)
 * You can delete old transactions using bulk action on TeraWallet page.
 * ![](https://i0.wp.com/snipboard.io/AhTNEH.jpg?ssl=1)
 *  Thread Starter [anonwins](https://wordpress.org/support/users/anonwins/)
 * (@anonwins)
 * [2 years ago](https://wordpress.org/support/topic/database-keeps-growing/#post-17739763)
 * Thank you!
 * So it’s just this:
 * `$current_balance = woo_wallet()->wallet->get_wallet_balance( $user_id, 'edit');
   
   delete_user_wallet_transactions( $user_id, true );if ( $current_balance ) woo_wallet()-
   >wallet->credit ($user_id, $current_balance, __( 'Balance after deleting transaction
   logs', 'woo-wallet' ) );
    -  This reply was modified 2 years ago by [anonwins](https://wordpress.org/support/users/anonwins/).
    -  This reply was modified 2 years ago by [anonwins](https://wordpress.org/support/users/anonwins/).

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database keeps growing’ is closed to new replies.

 * ![](https://ps.w.org/woo-wallet/assets/icon-256x256.png?rev=3360666)
 * [Wallet for WooCommerce](https://wordpress.org/plugins/woo-wallet/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-wallet/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-wallet/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-wallet/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-wallet/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-wallet/reviews/)

## Tags

 * [clean](https://wordpress.org/support/topic-tag/clean/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [delete](https://wordpress.org/support/topic-tag/delete/)
 * [remove](https://wordpress.org/support/topic-tag/remove/)
 * [transactions](https://wordpress.org/support/topic-tag/transactions/)

 * 3 replies
 * 2 participants
 * Last reply from: [anonwins](https://wordpress.org/support/users/anonwins/)
 * Last activity: [2 years ago](https://wordpress.org/support/topic/database-keeps-growing/#post-17739763)
 * Status: not resolved