[@kevinjohngallagher Member 16 years, 4 months ago]

ooooh bb_update_forum. Awesome find.

thats the difference between someone who can actually code PHP and someon like me.

I’ll have to play with it though, and might ask you for some help, as in some re-ordering will fire that once for each forum is manually updated by an admin. I mean that won’t happen often ofc, but it’s (number of SQL calls my function makes * each function affected).

Currently, and in no way overly optimized, the “forum_family_tree_setup” script uses 2 + (3 * parent) SQL calls per per forum.

Even on my large football forum, (large in terms of number of forums) which has quite deep relationships, this is far less intensive than a recount. If this was to be multiplied by 3 or 4 times though (depending on how many forums are updated with a move), that might cause a hic-up.

I’ll do some benchmarks after the weekend – I’ve got 31 non-England teams to support in the World Cup this weekend

Cheers bro!