If there ever comes a proper Blog solution for Xenforo, we can finally migrate from vBulletin 3.8. to XF.
In relation to this migration I have a question:
In my vB installation the attachments are stored in the database. I understood Xenforo keeps the attachments in a separate filesystem?
Question: for the migration process, is it advisable that I first put the vB attachments in the vB filesystem as well, and after that migrate to Xenforo?
Another question, which is more or less unrelated to XF specifically, but dare I ask it? :
My hostingprovider wants us to move from a Shared server to a much more expensive VPS. They say our vB platform uses too much resources:
- Overhead on database (3GB in size)
- Bad queries (they run for more than 10 secs)
- Indexes on tabels
Strange they complain now, since the last 5 years the amount of visitors/traffic to our forums has been reduced by almost 40% (!).
So, before migrating to XF (which is still impossible to do at the moment without a Blog solution), I would like to know if putting these attachments in the filesystem does any good to the performance? In other words, what are the pros and cons of putting attachments in the database or filesystem?