Reminder: storing blobs outside of the database makes them vulnerable to all sorts of transaction-
related problems (handling multiple copies at once, rolling back and not getting to delete the
file, deleting early, file being moved without knowledge, handling update locks against the row and
against the file as well) as well as security problems (someone has to have access to those files
as well as to the database, permissions are not centralized between database and filesystem) ...

Storing those files outside the database is faster for a lot of things, but there -are- drawbacks
to consider.

-Philip

---------- Original Message -----------

> The better way to is not to do it!
> Store the file outside the db and store a reference to it in the db - a lot
> faster.
> Think also of how long it will take to backup and restore such a database.
>
> Alan

------- End of Original Message -------