Binary Date

[Mystic Stylez]

I received this mailing from my host:

After importing the database (which was larger than normal) I found out why.
For some reason, this forum puts attachments, custom avatars and other
binary info into the database. This isn't a good idea because huge files
like this screw up the database caching. Also, attachments are a liability
if a user attaches copyrighted material or huge files. Any chance that we
can disable attachments? It's 15.3MB worth of binary data. Custom avatars
are about 1.6MB worth of binary data (instead of just pointers to the avatar
images on server). Any option to make these just files instead of stored in
the database?

Any solutions for me? I want to be able to keep the custom avatars and attachments.

[The Prohacker]

Originally posted by Mystic Stylez
I received this mailing from my host:



Any solutions for me? I want to be able to keep the custom avatars and attachments.



Tell your host to get a real :D 15.3mb for attachments is small....


Heck, one forum I admin on has around 200mb of attachments.. And everything is running just fine.. The copyrighting isn't really a problem with storing stuff in a db, that can happen if you store them as regular files.... If your host can't handle this, get a new host, because with lame excuses like that, they either don't know much about running a server, or are just plain stupid..

If one of my techs said that to a customer, I'd fire them...

[Mystic Stylez]

well ive found the avatar and attachment hack on vb.org to store them as files and not onto the database, so it wont be a problem at all anyways now.