Re: Ozone speed

[Stan Pinte <stan.pinte@wanadoo.be>]

At 16:26 12/06/2001 +0200, Falko Braeutigam wrote:
>On Tue, 12 Jun 2001, Stan Pinte wrote:
> > hello,
> >
> > I have a small problem:
> >
> > I have a simple client-server program, which is doing 150 writes to the
> > database, and this takes more or less 12 seconds...I guess I have done
> > something wrong.
> >
> > Would someone point me to some good benchmarking code?
>
>See the samples in $OZONE_HOME/samples. You may start with simple and then
>check the OO1 benchmark sample.
>
>You probably did your 150 "writes" (calling update methods I guess) from the
>client code. Thus, each method call results in a roundtrip to the server and a
>complete transaction begin/prepare/commit cycle - which is probably not
>intended and slow. Putting the 150 item loop into a method of a database 
>object
>is the solution. It's much faster _and_ encloses the entire work in _one_
>transaction.


Well, my Postgresql relational engine handles 150 writes in a lot less than 
12 seconds...

I want to make heavy use of the database...

Can someone point me to raw transactional performance data about ozone? Is 
the engine fast?

>This (very important) point isn't covered that much in the current docs. The
>Ozone Doc Project is underway to change this. :)
>Any news for the users list from the ODP crew?
>
>
>Falko
>--
>______________________________________________________________________
>Falko Braeutigam                              mailto:falko@smb-tec.com
>SMB GmbH                                        http://www.smb-tec.com