> I can assure you that storing images in BLOB does not bloat a
> database. They are designed for this very thing.

I would agree with you about the choice of the word "bloat", but relational
databases are hardly designed for storing binary data - it's purely an
afterthought at most. Relational databases are very good at storing and
retrieving character strings, and SQL is appropriate for searching character
strings. Neither is especially adept for working with binary data. In most
cases, I've found little or no benefit in storing binary data in a database
instead of just storing it on the filesystem, and in some cases, I've found
that filesystem storage performs a lot better and is easier to implement.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to