> database. They
> are designed for this very thing. Though I will admit that Oracle is
> far
> better than SQL Server at doing it. I have never really dealt with
> mySQL and
> it's been years since I used Informix so I can't tell you much on those
> products.
>
Bloat may not be the best way to term it. However, storing BLOBs and
CLOBs in a relational database leads to spatial issues since the
database has to pull data from multiple parts of the disk when
returning each row. Generally, the database keeps data in a table all
in the same part of a disk such that pulling it is efficient. Thus, as
more and more of these objects are added to the database things start
to slow down. Depending on the application the slow down may not be
even noticed; it all depends.
Relational databases were never designed to store these types of
objects, they only put them in because that is what customers want and
it was a good way to fight back against the OO databases. The truth is
that relational databases have become the silver bullet for long term
persistence even if they aren't the most appropriate solution.
-Matt
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
