> In addition to partitioning, make sure you understand that with LOB
> data, you have the option to store the data in the database blocks as
> a normal column or externally to the rest of the row. Given the size
> of the data you're talking about, I would imagine that external
> storage would be a performance win for you. This should let you go
> down path #1 rather than #2.
Hmm... 20M of files in a single file system directory? Unless you partition
on file system level (creating new directory for each month, or even
for each week), you'll end up with very slow data retrieval... Besides,
these files will be out of Oracle control and you won't be able to backup
and/or restore them using Oracle tools, you won't even be able to ensure
the files are there and were not changed since initial upload. For me,
range partitioning by month or even week with BLOBs being stored out of
row and each partition living in its own tablespace (to keep tablespace
sizes under control for sensible backup and recovery times) is the only
sensible approach here. I may be wrong of course.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Mon Sep 23 2002 - 09:36:21 CDT
