Thank You Like - Recount very slow
(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.