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

[Stuart Wright]

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

 

[TickTackk]

Batch Update Threads?

 

[Stuart Wright]

Batch Update Threads?

At the rate it's taking the system, it will take days.

 

[Xon]

@Stuart Wright You will need to re-index all the threads after updating the xf_thread table.

 

[a.ali]

Moving all threads within a category to a new location

 

[Stuart Wright]

Moving all threads within a category to a new location

No, just older threads from one forum to another within the same category.
It makes much more sense to UPDATE xf_thread SET node_id = 123 WHERE node_id = 456 and post_date < 'a year ago'.
So long as everything is good after doing a thread reindex, I think that's the best way to go.

 

[Stuart Wright]

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