Title: Optimize database tables
Last modified: January 13, 2023

---

# Optimize database tables

 *  Resolved [karmeljuk](https://wordpress.org/support/users/karmeljuk/)
 * (@karmeljuk)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/optimize-database-tables-4/)
 * ![](https://i0.wp.com/i.postimg.cc/hvVRcwLV/mailer.png?ssl=1)
 * Hello
   I have extremely huge wp_ig tablesIs it possible to clean this table queue?
 * Thanks

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

 *  Plugin Contributor [Shubhanshu Kandani](https://wordpress.org/support/users/shubhanshukandani/)
 * (@shubhanshukandani)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/optimize-database-tables-4/#post-16375802)
 * Hi [@karmeljuk](https://wordpress.org/support/users/karmeljuk/) ,
   Thanks for 
   reaching out to us! Hope you’re doing well.
 * These two tables, are associated with email sending data such as sent, in the
   queue, paused, failed, or scheduled campaigns, so you can delete it.
 * However, deleting tables will delete the campaigns related to them. Currently,
   you can delete the report from
    - Icegram Express -> Reports –>** Bulk delete**.
    - Through a database management tool like**[ phpMyAdmin](https://wordpress.org/plugins/wp-phpmyadmin-extension/)**.
      It is recommended when you have experience managing databases.
 * Additionally, we are planning to add a feature that will automatically delete
   the older reports in the plugin. This feature is on the roadmap.
 * We’ll let you know once it’s launched.
 * Happy to support you!
 *  Thread Starter [karmeljuk](https://wordpress.org/support/users/karmeljuk/)
 * (@karmeljuk)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/optimize-database-tables-4/#post-16376720)
 * Hi [@shubhanshukandani](https://wordpress.org/support/users/shubhanshukandani/)
   
   Thanks for the replay. Is it possible to select all reports? I have 33,785 items
   and I can select only 20 items at once
 *  Plugin Contributor [Shubhanshu Kandani](https://wordpress.org/support/users/shubhanshukandani/)
 * (@shubhanshukandani)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/optimize-database-tables-4/#post-16380908)
 * Hi [@karmeljuk](https://wordpress.org/support/users/karmeljuk/),
 * Yes! Currently, you can only select 20 reports on the report page.
 * Alternatively, you can delete reports directly from the database. You can delete
   them if you are familiar with database handling.
 * It is recommended to take a backup of the database before deleting it just for
   safety. Let me know if you need any assistance related to it.
 * Thanks!
 *  Thread Starter [karmeljuk](https://wordpress.org/support/users/karmeljuk/)
 * (@karmeljuk)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/optimize-database-tables-4/#post-16385868)
 * Hi [@shubhanshukandani](https://wordpress.org/support/users/shubhanshukandani/)
   
   Thank you for your help
 *  Plugin Contributor [Shubhanshu Kandani](https://wordpress.org/support/users/shubhanshukandani/)
 * (@shubhanshukandani)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/optimize-database-tables-4/#post-16414122)
 * Hello @karmeljuk ,
 * Thanks for your response!
 * I am closing this thread for now. Feel free to reopen it in case if you are having
   issues or doubts with the latest version of the plugin.
 * Also if you have any other queries, you can open a new thread from [here](https://wordpress.org/support/plugin/email-subscribers/#new-topic-0).
   We will be happy to assist you further.
 * Thank you.

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

The topic ‘Optimize database tables’ is closed to new replies.

 * ![](https://ps.w.org/email-subscribers/assets/icon-256x256.png?rev=2274172)
 * [Email Subscribers & Newsletters - Email Marketing, Post Notifications & Newsletter Plugin for WordPress](https://wordpress.org/plugins/email-subscribers/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/email-subscribers/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/email-subscribers/)
 * [Active Topics](https://wordpress.org/support/plugin/email-subscribers/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/email-subscribers/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/email-subscribers/reviews/)

## Tags

 * [optimisation](https://wordpress.org/support/topic-tag/optimisation/)

 * 5 replies
 * 2 participants
 * Last reply from: [Shubhanshu Kandani](https://wordpress.org/support/users/shubhanshukandani/)
 * Last activity: [3 years, 4 months ago](https://wordpress.org/support/topic/optimize-database-tables-4/#post-16414122)
 * Status: resolved