vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Community Lounge (https://vborg.vbsupport.ru/forumdisplay.php?f=13)
-   -   Pruning takes a long time... :) (https://vborg.vbsupport.ru/showthread.php?t=49705)

Erwin 03-06-2003 02:26 AM

Pruning takes a long time... :)
 
I decided to remove 20,000 posts from my forums as they were redundant, so I decided to use the Mass Prune option for the first time...

It is really slow! :) It's still going on and it's been 30 minutes already... I have this fear that I am deleting all my forum posts!!! :) Obviously not, but I'm keeping a close eye on things...

mr e 03-06-2003 02:40 AM

hey, at least you HAVE a lot of posts, my forum has diddly squat, pruning 20,000 posts would put us at about -6,000 posts :p

Chris Gwynne 03-06-2003 03:10 AM

Getting rid of 20,000.... thats a brave step.

*pats on back* ;)

Chris Gwynne 03-06-2003 03:11 AM

Question: Who, apart from Erwin :p, bothers with the Prune System?

I've never found a need for it.

Erwin 03-06-2003 03:14 AM

It's over an hour... getting few strange User CP db errors... but it's getting there. :) 10,000 posts are gone!

These are posts by guests from a long time ago... not accessible to the public... might as well get rid of them.

mr e 03-06-2003 03:16 AM

lol, i've never had enough posts to worry about pruning

Brad 03-06-2003 03:31 AM

Hehe, try using the mass move option for the frist time and moving 40,000 post from all forums into one by misteak......i lied and told everyone someone hacked into the DB LOL

N9ne 03-06-2003 05:43 AM

LOL @ AL.

@ Erwin: Speed of pruning depends on the server. If you have a megafast server, it doesn't take so long, especially when your site is the only one on it.

I've pruned about 100,000 posts once, on my Dual Athlon MP 1800+ with just my site on the server, BAM! it was fast...My DB is about 90MB right now, if I didn't prune, *shudders*

Xenon 03-06-2003 11:44 AM

well, pruning by username is very fast, because the information is in the post, but pruning threads of a special forum takes a long time, because first it must get the threadid's of the threads which are in the pruned forum, and then deleting the posts.

every deleted posts would be unindexed, that's what takes a while....

so if you delte the majority of your posts, maybe delete them with phpmyadmin and afterthat reindex the searchengine would be fasster ;)

Dean C 03-06-2003 03:43 PM

The pruning time for me will come in 6 months when we hit 1 million posts ;)

- miSt


All times are GMT. The time now is 03:40 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01926 seconds
  • Memory Usage 1,722KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete