Recount gets stuck on "Counting topics to which each user has replied"
-
Hi All,
I hope you can help.
I am trying to do a recount (BBPress 0.9.0.4).
What happens is that the first few items in the Recount list get done. Then the system goes to
“Counting topics to which each user has replied…”
And gets stuck there.
I tried not checking the box for “Count topics to which each user has replied”, and when I do this, the Recount function goes through every item in the list and satisfactorily completes it. But if I check this one single box (or all of them), it always gets stuck on this step.
I have tried deactivating all plugins and the problem persists.
-
Okay I had never written the special routine for “topics to which each user has replied” so it never even appeared in the last 0.9 although Sam incorporated some of my other improved queries.
But I sat down and wrote it just for you now
http://bbshowcase.org/plugins/fast-recount.zip
Basically the old 0.9 bbPress api loops through each and every user and does a few queries for each one, completely overloading any server and timing out and never finishing.
ie. 6 queries per user x 1000 users = 6000 queries !!!!
My version accomplishes the exact same results with only a handful of queries right inside the mysql engine regardless of how many users, so it should always finish in under 30 seconds (unless perhaps it’s millions of users)
Once you install and activate, under your recount menu you will see (among others)
FAST RECOUNT topics to which each user has replied
So check that box and leave the old one unchecked.
Until I have some time to fix the order in which the boxes appear, you should probably do the fast recount AFTER the other regular counts are done.
Oh and last but certainly not least, I highly recommend backing up your mysql database for wordpress/bbpress before using this plugin, because it’s experimental and does actually delete old data before creating the new data. Something could go wrong (in theory you could run it a second time to fix the problem but always best to be safe).
ps. make sure you update bbpress to 0.9.0.6 too
Okay I had never written the special routine for “topics to which each user has replied” so it never even appeared in the last 0.9 although Sam incorporated some of my other improved queries.
But I sat down and wrote it just for you now
http://bbshowcase.org/plugins/fast-recount.zip
Basically the old 0.9 bbPress api loops through each and every user and does a few queries for each one, completely overloading any server and timing out and never finishing.
ie. 6 queries per user x 1000 users = 6000 queries !!!!
My version accomplishes the exact same results with only a handful of queries right inside the mysql engine regardless of how many users, so it should always finish in under 30 seconds (unless perhaps it’s millions of users)
Once you install and activate, under your recount menu you will see (among others)
FAST RECOUNT topics to which each user has replied
So check that box and leave the old one unchecked.
Until I have some time to fix the order in which the boxes appear, you should probably do the fast recount AFTER the other regular counts are done.
Oh and last but certainly not least, I highly recommend backing up your mysql database for wordpress/bbpress before using this plugin, because it’s experimental and does actually delete old data before creating the new data. Something could go wrong (in theory you could run it a second time to fix the problem but always best to be safe).
ps. make sure you update bbpress to 0.9.0.6 too
- You must be logged in to reply to this topic.
