No announcement yet.

Attachments in dB or file system, is there really a performance difference?

  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Sorry if I bump this thread but I figured I reply with my own experiences.

    I run a forum with 1.4M+ attachments, daily about 2,000 to 10,000 attachments are added (depends entirely on the weather and day of the week). However with a Attachment storage amount of 928GB it is impossible to load the attachments through the Database, even though I would much prefer it this way. Due to the significantly easier management of the attachments and checking for duplicates and of course integrating the attachments into other pages.

    Now vbulletin has changed a lot over when I first used it back in v2.0 but back then having a DB of 6GB of attachments already slowed down the forum to horrible speeds. When using the 3.6x and later 3.8x I found that after 10 to 20GB of attachments in the Database the forum will slow down significantly.

    So yes I think putting attachments in a database is very handy and could perform very well if you have smaller size attachments and the size of the attachments in a whole don't take too much space but after a while, you really want to consider putting them on file storage as your Database will refuse to even open the main page.

    Stats of the forum are about 600 to 800 people online, 1.4M+ attachments, 32GB of Ram, Dual Quad Core and 4x 1TB HDD's.


    • #17
      I always move the attachments to the file system, also profile pics, sig pics and custom avatars.
      -- Web Developer for hire
      ---Online Marketing Tools and Articles


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