about? Of course they just scratched the surface in 8i but in 9i it's all
about that. I can search binary data, both clob and blob. They can be stored
within the database structure itself or in separate files associated with
the db structure. They have little or nothing to do at all with relational
modeling.
We currently have functionality that allows us to store PDF in Oracle and
search the BLOB for content. Now, of course, that won't work with images and
more proprietary formats that are not conducive to text searching but it
works perfect for us. We even ran comparisons against retrieval and write
vs. write/read. So long as you stream output using JSP we find that the DB
is faster than the filesystem most always.
Granted our Oracle environment runs on Digital UNIX so I haven't tried this
on NT running UNIX. Also If you are on SQL server I am sure the differences
may be somewhat less desirable as well.
But that's just IMHO regardless.
Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101
Office Phone 606.920.7447
Cell Phone 606.831.4590
_____
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 11:15 AM
To: CF-Talk
Subject: RE: Images - store in DB or filesystem?
> 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/ <http://www.figleaf.com/>
voice: (202) 797-5496
fax: (202) 797-5444
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
