headers
Arnold Maderthaner | 5 Apr 2006 13:36
Picon

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
Permalink | Reply |
headers
mikael-aronsson | 5 Apr 2006 14:41
Picon

Re: Performance tuning of ozone db

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).
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
Permalink | Reply |
headers
Arnold Maderthaner | 5 Apr 2006 19:13
Picon

Re: Performance tuning of ozone db

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

On 4/5/06, mikael-aronsson <mikael-aronsson <at> telia.com> wrote:
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).
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

Permalink | Reply |

Gmane