Hello
I'm in charge of the administration of the French https://forum.joomla.fr forum.
Months after months our forum becomes really slow. We're seeing "Working..." almost all the time, even for a simple redirection.
Our sysadmin has tried a lot of things (don't know exactly which ones) and, now, I'm trying to make a few cleaning since our forum exists for more than 10 years.
I'm trying, thus, to make a few cleaning like removing soft deleted posts. I've found the "Prune topics manager".
First try : I say yes for "Topic is unpublished/soft deleted" and select a channel. 797 messages are found. Ok, let's delete them.
After 15 seconds, I receive an error page "Service Unavailable - The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later" and when I try again, same selection, the system mention 738 messages.
So, vBulletin has indeed remove 59 records but I didn't imagine to do it again and again until vBulletin say "0 message found". We've a lot of channels.
Can you please tell me how I can do this cleaning action at once. F.i. by the user of a SQL query ?
Thanks for your help.
Objective : making our forum great again ;-)
I'm in charge of the administration of the French https://forum.joomla.fr forum.
Months after months our forum becomes really slow. We're seeing "Working..." almost all the time, even for a simple redirection.
Our sysadmin has tried a lot of things (don't know exactly which ones) and, now, I'm trying to make a few cleaning since our forum exists for more than 10 years.
I'm trying, thus, to make a few cleaning like removing soft deleted posts. I've found the "Prune topics manager".
First try : I say yes for "Topic is unpublished/soft deleted" and select a channel. 797 messages are found. Ok, let's delete them.
After 15 seconds, I receive an error page "Service Unavailable - The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later" and when I try again, same selection, the system mention 738 messages.
So, vBulletin has indeed remove 59 records but I didn't imagine to do it again and again until vBulletin say "0 message found". We've a lot of channels.
Can you please tell me how I can do this cleaning action at once. F.i. by the user of a SQL query ?
Thanks for your help.
Objective : making our forum great again ;-)
Comment