Eric Roby wrote:
>Is anyone successfully using OracleStorage in a production system or
>(better yet) as a storage server in a ZEO configuration ? It doesn't
>appear that any work has been done on it for nearly 18 months. Will
>OracleStorage work with the DCOracle2 product in support of 9i ?
>Thanks in advance
There's a modified version of OracleStorage in DCOracle2 -- thats why
you don't see any activity on the other module.
I've loaded an extremely large data set into it in in-house testing, and
there are one or two clients out there using it, but I cannot identify
them to you.
With a well-tuned Oracle, I find that Oracle Storage is about 5 times
slower than File Storage -- which is actually fantastic, given that its
a lot easier to append onto the end of a file than it it to update
tables in a RDBMS, so that a factor of 5x is really quite good! I
actually think you can do better than 5x, but it requires having a very
IO-balanced system -- the one I tested on was Oracle 9i using 3 drives
to separate out data areas.
However, keep in mind that Oracle Storage still stores pickled data into
Oracle -- it doesn't do any object-relational mapping for you or
anything like that; so you can't do operations on Zope data easily from
within Oracle (although it's notionally possible to integrate a
de-pickler as a PL/SQL loadable module so that you could actually
inspect a pickle from inside PL/SQL.)
I have used this in a ZEO envrionment; it works as you would expect (you
pop out the ZEO server's FileStorage and replace it with an
OracleStorage). Because the ZEO clients will cache objects if they have
the ZEO_CLIENT environment variable set, I normally focus on write speed
as being the dominant storage limiting factor, not read speed.
And of course, as the obligatory plug: Zope Corporation is always
willing to undertake specific support engagements should you have the
requirement to have on-call support. Our web page with an overview of
this is http://www.zope.com/Services/SupportContracts should you have an
Zope-Dev maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -