Re: Performance tuning of ozone db

------=_Part_34800_2322266.1144257181916
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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 setting=
s
but they didn't effect it in any way.

yours

arnold

On 4/5/06, mikael-aronsson <[email protected]> wrote:
>
> I guess it all, depends on how you do it, 33ms for each insert is not ver=
y
> 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 <[email protected]>
> *To:* [email protected]
> *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
>
>

------=_Part_34800_2322266.1144257181916
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi Mikael !<br>
<br>
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.<br>
<br>
yours<br>
<br>
arnold<br><br><div><span class=3D"gmail_quote">On 4/5/06, <b class=3D"gmail=
_sendername">mikael-aronsson</b> &lt;<a href=3D"mailto:mikael-aronsson@teli=
a.com">[email protected]</a>&gt; wrote:</span><blockquote class=3D"=
gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0p=
t 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style=3D"direction: ltr;">






<div><font face=3D"Arial" size=3D"2">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=3D"Arial" size=3D"2"></font>&nbsp;</div>
<div><font face=3D"Arial" size=3D"2">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><div style=3D"direction: ltr;"><span class=3D"sg">
<div><font face=3D"Arial" size=3D"2"></font>&nbsp;</div>
<div><font face=3D"Arial" size=3D"2">Mikael</font></div></span></div><div s=
tyle=3D"direction: ltr;"><span class=3D"e" id=3D"q_10a6a1319b1d04d0_2">
<blockquote style=3D"border-left: 2px solid rgb(0, 0, 0); padding-right: 0p=
x; padding-left: 5px; margin-left: 5px; margin-right: 0px;" dir=3D"ltr">
  <div style=3D"font-family: arial; font-style: normal; font-variant: norma=
l; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adj=
ust: none; font-stretch: normal;">----- Original Message ----- </div>
  <div style=3D"background: rgb(228, 228, 228) none repeat scroll 0% 50%; -=
moz-background-clip: initial; -moz-background-origin: initial; -moz-backgro=
und-inline-policy: initial; font-family: arial; font-style: normal; font-va=
riant: normal; font-weight: normal; font-size: 10pt; line-height: normal; f=
ont-size-adjust: none; font-stretch: normal;">
<b>From:</b>=20
  <a title=3D"[email protected]" href=3D"mailto:arnold.maderthan=
[email protected]" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(window=
,event,this)">Arnold Maderthaner</a> </div>
  <div style=3D"font-family: arial; font-style: normal; font-variant: norma=
l; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adj=
ust: none; font-stretch: normal;"><b>To:</b> <a title=3D"ozone-users@lists.=
sourceforge.net" href=3D"mailto:[email protected]" target=
=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this)">
[email protected]</a>=20
  </div>
  <div style=3D"font-family: arial; font-style: normal; font-variant: norma=
l; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adj=
ust: none; font-stretch: normal;"><b>Sent:</b> Wednesday, April 05, 2006 1:=
36=20
  PM</div>
  <div style=3D"font-family: arial; font-style: normal; font-variant: norma=
l; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adj=
ust: none; font-stretch: normal;"><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 wrot=
e=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:25=
3=20
  ms<br>remove 1000 persons:15271 ms<br><br>Hopefully you can help=20
  me.<br><br>yours<br></div></blockquote><span></span>

</span></div></blockquote></div><br>

------=_Part_34800_2322266.1144257181916--


-------------------------------------------------------
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