No announcement yet.

Dividing the Database

  • Filter
  • Time
  • Show
Clear All
new posts

  • Dividing the Database


    I have a problem with my database it is about 800 MBs now with a half million of posts.

    The problem is it's getting larger and larger everyday and that's makes the server very slow and have to upgrade my server every while.

    Is there a solution for that ? like dividing the post table into number of tables so that the MySQL engine doesn't have to mine all the 500,000 posts to get a one post or something ?

    Is that possible ?

    Thanks in advance.

  • #2
    Sorry, there is no function to do this. This requires modifying the code. We cannot officially support code modifications or forums running modified code, however you can try searching or asking for help with this over at
    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.


    • #3
      That's not a large database, additionally unless you have major I/O restrictions or general issues on your host - it should not be slowing down on 500k dataset.
      anders | vbulletin team | check out the new vbulletin facebook app
      Proudly vBulletin'ing since 2001
      Please be my friend!
      vBulletin Performance Articles:
      Click here to read


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