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
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?