Re: Performance tuning of ozone db
"mikael-aronsson" <[email protected]> Wed, 5 Apr 2006 14:41:55 +0200
| Newsgroups | gmane.comp.java.ozone.user |
|---|---|
| Message-ID | <002101c658ae$527aa140$c29c143e@w128mtec> |
This is a multi-part message in MIME format. ------=_NextPart_000_001E_01C658BF.15E95990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 -----=20 From: Arnold Maderthaner=20 To: [email protected]=20 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.=20 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 ------=_NextPart_000_001E_01C658BF.15E95990 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I guess it all, depends on how you do = it, 33ms for=20 each insert is not very bad if you consider that each insert means a=20 send/process/return over the network.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>If you look at the documentation there = are=20 information about what options you can change and what effect they will=20 have.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Mikael</FONT></DIV> <BLOCKQUOTE dir=3Dltr=20 style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20 <A [email protected]=20 href=3D"mailto:[email protected]">Arnold Maderthaner</A> = </DIV> <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20 [email protected]=20 = href=3D"mailto:[email protected]">[email protected]= eforge.net</A>=20 </DIV> <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, April 05, 2006 = 1:36=20 PM</DIV> <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [Ozone-users] = Performance tuning=20 of ozone db</DIV> <DIV><BR></DIV> <DIV style=3D"DIRECTION: ltr">Hi !<BR><BR>How can I do some = performance tuning=20 of the ozone db. <BR>I didn't some performance test with an object I = wrote=20 (class Person which has one string and on int).<BR>My = results:<BR>insert 1000=20 persons: 33000 ms<BR>update 1000 persons:12139 ms<BR>show 1000 = persons:253=20 ms<BR>remove 1000 persons:15271 ms<BR><BR>Hopefully you can help=20 me.<BR><BR>yours<BR></DIV></BLOCKQUOTE><SPAN = class=3Dsg></SPAN></BODY></HTML> ------=_NextPart_000_001E_01C658BF.15E95990-- ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642