mysql blob 好处_什么时候使用MySQL BLOB推荐？

I'm coding an application that will be uploading and deleting many files, i usually just move the files to a folder in the server naming them with the row unique id. But as i understand MySQL also lets me store binary data (files) when would this be a better choice?.

Please use solid arguments, like When

does using BLOB will mean performance

improvement?.

P.S: I'm using MyISAM if that matters.

Thanks.

UPDATE:

UPDATE 2

Storing the files in the database is

not a need i'm trying to know when

is this a better idea than storing

them in folders.

解决方案

Read:

which concludes

If you on occasion need to retrieve an

image and it has to be available on

several different web servers. But I

think that's pretty much it.

If it doesn't have to be available on

several servers, it's always better to

put them in the file system.

If it has

to be available on several servers and

there's actually some kind of load in

the system, you'll need some kind of

distributed storage.