Ratheesh K J wrote:
> I want to know whether this is the right approach. Or should we
> actually store the attachments in directories and just stiore the
> attachment path in the database.
Databases are designed to handle arbitrarily large numbers of rows of
structured data, where each datum is small and roughly the same size as
all others of its kind. Storing arbitrary data in a BLOB column is
tantamount to trying to turn the database into a file system. If you
want a file system, use a file system.
Microsoft's been promising a database-backed file system for something
like 15 years now. Maybe it's because they don't write software all
that well up there in Redmond. Or maybe it's because this is one of
those ideas that sounds good on paper but doesn't work out so well in
practice. I'm betting on the latter.