• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 I have 460,000 threads to move to a different forum. Can I do an SQL statement?

Stuart Wright

Well-known member
#1
Hi folks,
we've got slow queries running because our classifieds archive forum has 540,000 threads.
So I want to move the older ones out to a non-public forum.
At the rate it's taking the system, it will take days.
Can I just run a query to change the node id of the threads?
Thanks
 

Stuart Wright

Well-known member
#7
The SQL took I think less than a minute and the thread reindex just a small number of hours.
The whole process considerably quicker than the batch update