Thank You Like - Recount very slow
(2023-08-19, 11:40 AM)Laird Wrote:(2023-08-16, 04:03 PM)lost puppy Wrote: the last time I did a 'Recount & Rebuild' on the Thank You Like it took over 23 hours (actually I stopped it at near 24 hours because it was getting slower and slower)!
It began by sending between 300 to 400 queries per second and I stopped it when it was taking near 30 seconds per 300 - 400 .... at this point I think that it still had approx 1 million to do!
Mmm, yeah, looking at the code, it's terribly inefficient in terms of database queries.
(2023-08-16, 04:03 PM)lost puppy Wrote: How can I make this 'Recount' vastly quicker?
It could be done in a few manual queries, each of which might take a little while to run. If necessary, I can come up with those queries for you, however...
(2023-08-16, 04:03 PM)lost puppy Wrote: Else I do not think that I can do the upgrade as I may need to do a 'Recount'!
...there's nothing about an upgrade that would entail the need for a recount if one wasn't already required.
Thank you so much for your reply
It is good to read that an update will not require a recount ... that does allay my concerns.
I would very much like to have the 'like' count actually correct so, if I may impose on you, It would be brilliant to have the manual queries to run?
The forum is very quiet for approx 4-5 hours overnight so I could run them at that time (I would first run them on a 'test' site I have of the forum) and it would be no issue!
Again ... thank you for helping me
