No announcement yet.

Archive Posts/Threads

  • Filter
  • Time
  • Show
Clear All
new posts

  • Archive Posts/Threads

    Hi People,

    My post table is in excess of 380MB. My fourms are running fairly slow every time they got run a query on the post table because of its size.

    I want to prune my posts to 6months ago, but is there a way to keep all posts passed 6months and keep them in some kinda archive system?


  • #2
    Are you sure the size of the post table is slowing down your forums? If you want a performance analysis of your server setup then post a thread in the Server Configuration forum. Include the information requested in this thread.

    Regarding archiving your posts... vBulletin doesn't have a feature archive posts outside of the post table. I can't think of a good solution for you. The people might have some ideas.


    • #3
      I am 99% sure it is my post table...

      Everytime my server runs a query on the post table its taking about 2-3 seconds.. It might not seem much but with 100+ people online at one time it can get very cpu intensive..

      Thats why i wanted to make a archive system as i dont wanna loose the old posts

      Yep i asked, no answer for days now.


      • #4
        If you move the posts to an archive forum, they will still be part of the post table. Unfortunately you are going to need to write custom code for what you want to do.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography

        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        • #5
          Well that answers a question I know I would have been asking soon too!


          • #6
            I relise im gonna have to make custom code..

            oh well wish me luck! :P


            • #7

              I have set up an archive category, like on the vb forum, and have moved some forums into it. I have been trying to configure it so that on the main forum you can ONLY see the archive category with no forums under it, however when you click on the archive category, you should thenbe able to see the forums in it

              I have tried playing with all the forum settings but nothing seemsto work, they always appear as sub forums or just dont appear at all

              Ideally I want the archive category to remain collapsed at all times unless someone clicks on it

              Can anyone help me out??


              • #8
                Try the method in this thread.


                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.