Thank You Like - Recount very slow
Hi all and thanks for wonderful forum software and great plugins.
I have a forum which has over 3.5 million 'likes' in the database and as there is a new upgrade to the Thank You Like plugin, I would like to upgrade it .... but 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!
My question is:
How can I make this 'Recount' vastly quicker?
Else I do not think that I can do the upgrade as I may need to do a 'Recount'!
Many thanks for any advice.
MyBB version: 1.8.35
PHP: 8.0.30
MySQLi: 10.6.12
Plugins:
Thank You Like 3.4.4
Mention Me 3.2.12
My Alerts 2.0.4
Auto Media 4.1.1
My Insert Buttons 4.0.2
I have a forum which has over 3.5 million 'likes' in the database and as there is a new upgrade to the Thank You Like plugin, I would like to upgrade it .... but 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!
My question is:
How can I make this 'Recount' vastly quicker?
Else I do not think that I can do the upgrade as I may need to do a 'Recount'!
Many thanks for any advice.
MyBB version: 1.8.35
PHP: 8.0.30
MySQLi: 10.6.12
Plugins:
Thank You Like 3.4.4
Mention Me 3.2.12
My Alerts 2.0.4
Auto Media 4.1.1
My Insert Buttons 4.0.2