Thank You Like - Recount very slow

[Laird]

There are 6 queries (I think lol) and the first 4 .... each took seconds (I mean the db states 0.0004 for each one)

Excellent - I was hoping it would be fast even on a site with millions of thanks/likes.

Only problem was on the 5th query

Oh, I see - that's because the tyl_tnumtyls column was mistakenly removed (by me) from the core threads table in version 3.1.0 (August, 2018) of the plugin, and only reinstated in the latest version 3.4.5 (August, 2023), to which you have not yet upgraded.

I've updated the script (as attached in my previous post) to handle scenarios like yours. Please test the new version of the script (1.1.0) and let me know whether the error is avoided this time.

But it would definitely seem that it worked anyway 

Taking 2 members:

On the real site forum Member 1 has 29671 'likes' >> but now on the 'test' site the member has 33690
Member 2 on the real forum has 381953 'likes' >> on 'test' site they now have 424704

Speed wise .... well what can I say ... last time it took near 24 hours and didn't complete (I had to stop it) 

This took seconds!!

Stunning ... thank you so very much ... you are a super star 

That's great news. Cheers for the positive feedback.