UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Pruning Topics / Import Map

When I split my one big forum up into two smaller forums, I pruned away the excess topics in each smaller forum.

So for example in one smaller forum I now have only 8748 posts.

However, the ubbt_import_map file still has 157326 entries in it.

How can I prune down that import map file? Should this be automatically done when the posts are pruned?

You'd have to do it manually; that file just holds the post id's from your import from v6 (UBB.Threads or UBB.Classic) and isn't really touched by v7 unless via the importers.

i usually empty that table. it serves no real purpose, once your site has been running threads 7.x for awhile.

your SEO has probably been re-established in 7.x anyway, so no need for any redirects, anymore.

and it eliminates another overhead.

SD - I believe I emptied that table on the BellaOnline forum a few years ago. I think I had to make a code change to stop errors after that. I also think it caused some issues with broken links. In the forums themselves people often refer to another thread for more information. So I believe those referral links made when we were running v6 stopped working. So I think I'd like to keep the import map here so that doesn't happen.

If it's keyed on post ID, and there's no other concerns, then I'll run a query to look for any rows that don't have a matching post ID in the live posts table, and delete those. That sounds like it'll do what I need and speed things up further.

OK here's the steps I took in case someone else wants to do this.

verify data -
select count(*) from ubbt_import_map where post_id not in (select post_id from ubbt_posts);
156289 posts

prepare for delete based on post ID -
Added post_id primary key to ubbt_import_map

remove obsolete rows -
delete from ubbt_import_map where post_id not in (select post_id from ubbt_posts);
removed 156289 rows

optimize table -
size in db tools – started at 3mb
optimized – now at 64k

Let me know if you have any questions!