PDA

View Full Version : Multi Databases?


stunod
05-17-2009, 01:35 AM
I was just curious if it is possible to have more then just one database in vbulletin?

Maybe one just for images?

Thanks,
Adam

Lynne
05-17-2009, 02:20 AM
You could have another database, however if you put some of the vbulletin tables into the new one (and delete them from the old one), then you will have to modify all the code that queries any of those tables. That wouldn't be something easy to do. What would you hope to gain from this?

stunod
05-18-2009, 05:57 AM
My host "1and1.com" only offers a 100mb database and I have 25 of them available at 100mb, but it didn't take long to fill it up.

They offer a dedicated server with a bigger database for $120 a month. But I have been trying to avoid that!

I have been on the hunt for something to lower my database for sometime, but my attachment database is taking about 80% of my 100mb.

Adam

Dismounted
05-18-2009, 06:54 AM
Change your Attachment Storage Type to "File System".

Lynne
05-18-2009, 03:00 PM
Change your Attachment Storage Type to "File System".
And after you do that, make sure to run repair/optimize on your attachment table to reduce the size.