Title: Cleantalk wordpress database table record huge data size and index size Last modified: September 9, 2021 --- # Cleantalk wordpress database table record huge data size and index size * Resolved [parhamm](https://wordpress.org/support/users/parhamm/) * (@parhamm) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/) * Hi Support, * I was using WP Optimize to review my wordpress database table records and it appears that the cleantalk plugin I have is a huge file at 19.58 MB (data size) and 16.61 MB (index size). This is by far the largest database size compared to any plugin I use. Is there a more efficient way to address this as it slows down my website? Viewing 8 replies - 1 through 8 (of 8 total) * Plugin Support [amagsumov](https://wordpress.org/support/users/amagsumov/) * (@amagsumov) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14856343) * Hello, [@parhamm](https://wordpress.org/support/users/parhamm/) * Could you tell us your CleanTalk plugin version, WordPress version, PHP version and the name of that file? * Thread Starter [parhamm](https://wordpress.org/support/users/parhamm/) * (@parhamm) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14856400) * Security by CleanTalk Version 2.72.2 Anti-Spam by CleanTalk Version 5.161 * WP Version: 5.8 * PHP: 7.4.23 * WP Optimize specifies this table name: wp_spbc_firewall_data * Thread Starter [parhamm](https://wordpress.org/support/users/parhamm/) * (@parhamm) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14856418) * There are also numerous other tables that take up memory. One other very large one is : * Records Data Size Index Size wp_spbc_scan_results 25,551 10.02 MB 2.02 MB * There are many more smaller ones too. Let me know if you want me to specif those as well. * [SergeM](https://wordpress.org/support/users/serge00/) * (@serge00) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14857248) * Thank you for your feedback. I’ve passed your details to the programmer staff. We will write back to you within 2-3 business days. Please, wait. * [Safronik](https://wordpress.org/support/users/safronik/) * (@safronik) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14857348) * Hello [@parhamm](https://wordpress.org/support/users/parhamm/) * First of all, big tables don’t slows down your website by itself. Too often requests to the such table – that is the problem. * You don’t need to worry about **wp_spbc_scan_results** because this table is not so often in use. Once in a day for about 10 minutes (during the background scan if enabled). * Big **wp_spbc_firewall_data** could a problem. It’s already optimized in all possible ways. I’m not allowed to consult you about this here because of WordPress forums support rules. I could only say that you can reduce it by excluding a few countries ( in your case few tens ) from the personal lists in CleanTlak dashboard. * If you want to get more specific support about it, please, proceed here: [https://cleantalk.org/my/support/open](https://cleantalk.org/my/support/open) and open the ticket in our support system. Don’t forget to attach the link to this conversation. * Please, contact us. - This reply was modified 4 years, 7 months ago by [Safronik](https://wordpress.org/support/users/safronik/). * Thread Starter [parhamm](https://wordpress.org/support/users/parhamm/) * (@parhamm) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14859470) * Thanks for the reply and looking into this Safronik. * What compelled my investigation into this is that many web and optimization plugin developers recommend that website start to slow down when database record size gets too big / bloated. In this instance with the cleantalk plugin, I noticed that a significant number of records were due to Cleantalk plugins, so I surmised that I need to find a way to reduce these data table sizes to reduce bloating and hence help with website loading time. I will certainly look at the country exclusion list as you have suggested. I might even open a ticket to carry on with this conversation. Thanks. * Plugin Support [katereji](https://wordpress.org/support/users/katereji/) * (@katereji) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14859800) * Thank you [@parhamm](https://wordpress.org/support/users/parhamm/) for your feedback. I’ll pass your reply to our developers. If you have additional questions open a ticket as suggested. * Plugin Support [sergecleantalk](https://wordpress.org/support/users/sergecleantalk/) * (@sergecleantalk) * [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14892181) * Hello, * We haven’t heard back from you in a while, so I’m going to mark this as resolved– if you have any further questions, you can start a new thread. Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Cleantalk wordpress database table record huge data size and index size’ is closed to new replies. * ![](https://ps.w.org/security-malware-firewall/assets/icon-256x256.gif?rev=3518712) * [Security Plugin, Firewall, Malware Scanner & Removal](https://wordpress.org/plugins/security-malware-firewall/) * [Frequently Asked Questions](https://wordpress.org/plugins/security-malware-firewall/#faq) * [Support Threads](https://wordpress.org/support/plugin/security-malware-firewall/) * [Active Topics](https://wordpress.org/support/plugin/security-malware-firewall/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/security-malware-firewall/unresolved/) * [Reviews](https://wordpress.org/support/plugin/security-malware-firewall/reviews/) * 8 replies * 6 participants * Last reply from: [sergecleantalk](https://wordpress.org/support/users/sergecleantalk/) * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/cleantalk-wordpress-database-table-record-huge-data-size-and-index-size/#post-14892181) * Status: resolved