[Zope-dev] OracleStorage, and possibly others
Lalo Martins
lalo@hackandroll.org
Wed, 29 Nov 2000 17:30:12 -0200
On Wed, Nov 29, 2000 at 10:13:15AM -0500, Chris McDonough wrote:
> It sounds like you've done more comprehensive speed testing than we have.
> Can you share some numbers?
Unfortunately no, I can't. We made measurements during a
consulting job I did for another company, and it was made by
them, not me, *plus* I wasn't smart enough to save a copy of
the numbers :-/
Anyway, the biggest problem they had was stability, their ZODB
grows and shrinks insickening speeds, and Data.fs would break
for some reasons I don't remember anymore, and OracleFS solved
that. I'll try to convince them to write a report to the list.
> ----- Original Message -----
> From: "Lalo Martins" <lalo@hackandroll.org>
> To: <zope-dev@zope.org>
> Sent: Wednesday, November 29, 2000 8:42 AM
> Subject: Re: [Zope-dev] OracleStorage, and possibly others
>
>
> > On Wed, Nov 29, 2000 at 07:02:50AM -0500, Chris McDonough wrote:
> > > > Of course it would, for the same reasons as OracleStorage (eg
> > > > FileStorage/Data.fs is inefficient)
> > >
> > > Actually, it's the other way around. OracleStorage is 30-to-50 times
> slower
> > > than FileStorage on writes. Reads are slow too but the slowness is
> somewhat
> > > negated by caching.
> >
> > Chris, that's only true for small databases. At about 100M of
> > Data.fs, OracleStorage starts being faster. It depends on
> > hardware too. We made some benchmarks on a major Brazilian
> > portal, and well, it's currently running OracleStorage.
> >
> > Anyway, I said "inefficient", not "slow".
[]s,
|alo
+----
--
Hack and Roll ( http://www.hackandroll.org )
The biggest site for whatever-it-is-that-we-are.
http://zope.gf.com.br/lalo mailto:lalo@hackandroll.org
pgp key: http://zope.gf.com.br/lalo/pessoal/pgp
Brazil of Darkness (RPG) --- http://zope.gf.com.br/BroDar