Title: eladear's Replies | WordPress.org --- # eladear [ ](https://wordpress.org/support/users/eladear/) * [Profile](https://wordpress.org/support/users/eladear/) * [Topics Started](https://wordpress.org/support/users/eladear/topics/) * [Replies Created](https://wordpress.org/support/users/eladear/replies/) * [Reviews Written](https://wordpress.org/support/users/eladear/reviews/) * [Topics Replied To](https://wordpress.org/support/users/eladear/replied-to/) * [Engagements](https://wordpress.org/support/users/eladear/engagements/) * [Favorites](https://wordpress.org/support/users/eladear/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 42 total) 1 [2](https://wordpress.org/support/users/eladear/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/eladear/replies/page/3/?output_format=md) [→](https://wordpress.org/support/users/eladear/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] The impression data over time is creating a large database. Is there a solution](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [10 years, 10 months ago](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/#post-6565732) * I think I figured out the problem. You were mentioning the count is saved only one row, so that shouldn’t be heavy. Even with thousands of posts, because it is just a small bit of text. * And so I looked at your settings, and the database and there were like 1.7 million rows to wp-top-ten-daily, and about 2,500 posts. So something wrong. I’ve been using your plugin for some years now, so I think with a past version it duplicated the rows and that was creating a massive table. * I clicked “merge duplicates across blog IDs” and that reduced the table from 107mb to 116KB with 2,480 posts. Much better. * I’m going to do a few more tests to see if the count remained the same for most posts. * Thanks. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] The impression data over time is creating a large database. Is there a solution](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [10 years, 10 months ago](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/#post-6565731) * On WordPress, posts from 2010: [http://imgur.com/7SXMT9q](http://imgur.com/7SXMT9q) * Correct link. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] The impression data over time is creating a large database. Is there a solution](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [10 years, 10 months ago](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/#post-6565730) * Hi, * I have 107MB for the wp-top-ten-daily table. I’m trying to reduce its size by deleting the count to some posts. I have manually through WordPress > “View Popular Posts.” And by doing this, it has improved the size of the that table. Yet, doing it manually is a lot of work when there are thousands of posts. * I thought by using the cron schedule that anything older than 720 days would exclude some data related with the post count at wp-top-ten-daily. What is happening is it remains exactly the same at eye-view. * Database table: [http://imgur.com/ykf8LUq](http://imgur.com/ykf8LUq) * On WordPress, posts from 2010 * > [View post on imgur.com](https://imgur.com/ykf8LUq) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] The impression data over time is creating a large database. Is there a solution](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [10 years, 10 months ago](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/#post-6565724) * The total impressions per old post (2010, 2009) have not been deleted. I have posts with 10,000 views each. I thought it deleted the impression data accumulated for that post, resetting it and then counting new views. * I’m confused to what this actually does, because I see no change to the impresssions/ data of older posts. It doesn’t reduce the table weight, unless I manually delete the count to specific posts. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] The impression data over time is creating a large database. Is there a solution](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [10 years, 10 months ago](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/#post-6565718) * Through the WordPress panel, I still seeing the accumulation of views to older posts, and no change to wp_top_ten_daily. The only thing I’ve noticed making a change it manually delete count at “Top 10 Popular Posts.” * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] The impression data over time is creating a large database. Is there a solution](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [10 years, 10 months ago](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/#post-6565716) * I activated the maintenance mode to daily. And altered the number of days in top-10.php. But no change was made to the tables and data of those older posts. I had scheduled the delete to anything older than two years. 720 days. * Is there something else I should be doing for this to work? * Thanks. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] The impression data over time is creating a large database. Is there a solution](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [10 years, 11 months ago](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/#post-6565506) * Thanks. I’ve set it to a year. And have also deleted the count to some other posts not needed through the top 10 settings. * Time to run maintenance, I’ve left with default to 0. Not sure if this is the hour of the day or the time one allows the maintenance to run? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] The impression data over time is creating a large database. Is there a solution](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [10 years, 11 months ago](https://wordpress.org/support/topic/the-impression-data-over-time-is-creating-a-large-database-is-there-a-solution/#post-6565500) * Hi, * Is there any way to alter 90 days to a longer period of time, to not lose so much data? * > You can also use the new interface in the admin area to delete posts counts data you don’t wish to retain. * I’m not sure where the new interface is? How can I find this? * Thanks. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] Since the last plugin updates, the views on WP panel isn't showing correctly](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [11 years, 3 months ago](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/page/2/#post-5718463) * I wanted to send an update. I had downloaded the upgrade version of your plugin, did not even press the new button until seeing if anything changed first and doing a database backup. But your upgrade fixed the problem without altering settings. * Thank you. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] Since the last plugin updates, the views on WP panel isn't showing correctly](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [11 years, 4 months ago](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/page/2/#post-5718458) * That’s great. Thank you! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] Since the last plugin updates, the views on WP panel isn't showing correctly](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [11 years, 4 months ago](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/page/2/#post-5718454) * Thanks great! Thanks for making a great plugin. * When do you think it will be officially released? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] Since the last plugin updates, the views on WP panel isn't showing correctly](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [11 years, 4 months ago](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/page/2/#post-5718452) * I don’t understand enough about select queries and databases to do this. I will have to hire a developer to help look into this. * in the meantime, I had did the other things you had asked. I don’t notice the new posts having this bug (which is good), but the old ones continue to look the same. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] Since the last plugin updates, the views on WP panel isn't showing correctly](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [11 years, 6 months ago](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/#post-5718426) * I had tried, but I don’t understand enough to do this. I don’t want to make a mistake with content in the database. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] Since the last plugin updates, the views on WP panel isn't showing correctly](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [11 years, 6 months ago](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/#post-5718419) * I had, but I don’t understand enough to work with this plugin. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WebberZone Top 10 — Popular Posts] Since the last plugin updates, the views on WP panel isn't showing correctly](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/) * Thread Starter [eladear](https://wordpress.org/support/users/eladear/) * (@eladear) * [11 years, 6 months ago](https://wordpress.org/support/topic/since-the-last-plugin-updates-the-views-on-wp-panel-isnt-showing-correctly/#post-5718417) * Hi, * Yes, the problem only exists for some posts, but I don’t see anything wrong with the data on the WP post page or database. Just notice it not display the total and daily view well in the listings. Viewing 15 replies - 1 through 15 (of 42 total) 1 [2](https://wordpress.org/support/users/eladear/replies/page/2/?output_format=md) [3](https://wordpress.org/support/users/eladear/replies/page/3/?output_format=md) [→](https://wordpress.org/support/users/eladear/replies/page/2/?output_format=md)