Discussion:
[Ozone-users] Performance tuning of ozone db
Arnold Maderthaner
2006-04-05 10:02:05 UTC
Permalink
Hi !

How can I do some performance tuning of the ozone db.
I didn't some performance test with an object I wrote (class Person which
has one string and on int).
My results:
insert 1000 persons: 33000 ms
update 1000 persons:12139 ms
show 1000 persons:253 ms
remove 1000 persons:15271 ms

Hopefully you can help me.

yours
mikael-aronsson
2006-04-05 10:42:14 UTC
Permalink
I guess it all, depends on how you do it, 33ms for each insert is not very bad if you consider that each insert means a send/process/return over the network.

If you look at the documentation there are information about what options you can change and what effect they will have.

Mikael
----- Original Message -----
From: Arnold Maderthaner
To: ozone-***@lists.sourceforge.net
Sent: Wednesday, April 05, 2006 1:36 PM
Subject: [Ozone-users] Performance tuning of ozone db


Hi !

How can I do some performance tuning of the ozone db.
I didn't some performance test with an object I wrote (class Person which has one string and on int).
My results:
insert 1000 persons: 33000 ms
update 1000 persons:12139 ms
show 1000 persons:253 ms
remove 1000 persons:15271 ms

Hopefully you can help me.

yours
Arnold Maderthaner
2006-04-05 15:20:03 UTC
Permalink
Hi Mikael !

There is not much data to be transfered because the Person object is very
small and I tried it on local host. I allready tried to change some settings
but they didn't effect it in any way.

yours

arnold
Post by mikael-aronsson
I guess it all, depends on how you do it, 33ms for each insert is not very
bad if you consider that each insert means a send/process/return over the
network.
If you look at the documentation there are information about what options
you can change and what effect they will have.
Mikael
----- Original Message -----
*Sent:* Wednesday, April 05, 2006 1:36 PM
*Subject:* [Ozone-users] Performance tuning of ozone db
Hi !
How can I do some performance tuning of the ozone db.
I didn't some performance test with an object I wrote (class Person which
has one string and on int).
insert 1000 persons: 33000 ms
update 1000 persons:12139 ms
show 1000 persons:253 ms
remove 1000 persons:15271 ms
Hopefully you can help me.
yours
Loading...