eladear
Forum Replies Created
-
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.
On WordPress, posts from 2010:
http://imgur.com/7SXMT9qCorrect link.
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/ykf8LUqOn WordPress, posts from 2010
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.
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.”
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.
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?
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.
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.
That’s great. Thank you!
Thanks great! Thanks for making a great plugin.
When do you think it will be officially released?
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.
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.
I had, but I don’t understand enough to work with this plugin.
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.