prune is very slow!

[محروم.كوم]

Hi


I'm trying to prune the old messages in my forum and this seem to be taking a lot of time!

Now with around 3 hours from running the process, it seem it will take very long time:
here some numbers:
before: thread 230,550 post: 2,688,180
after 3 hours: thread: 200,619 post: 2,331,341

I'm targeting to reduce the post to less than 500,000. with this progress it seem will take weeks!

Also I notice that the overhead value in the DB for post and thread tables is increasing, now the post overhead is 207.7 MiB

Is this expected? Is there something wrong with the server? __DEFINE_LIKE_SHARE__