From romange@gmail.com Tue Aug 20 20:47:04 2013
From: romange@gmail.com
To: openldap-bugs@openldap.org
Subject: Re: (ITS#7667) performance degradation when using MDB_INTEGERKEY
Date: Tue, 20 Aug 2013 20:47:03 +0000
Message-ID: <201308202047.r7KKl3Fj076372@boole.openldap.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2474895974570553513=="

--===============2474895974570553513==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

--001a11c1e98008372804e46726c2
Content-Type: text/plain; charset=3DUTF-8

Hi, I extracted a small dataset that shows the problem.
you can download it from here:
https://docs.google.com/file/d/0B6o29pwkWoERdnFSaUtMNDljemc/edit?usp=3Dsharing

I modified mdb_copy.c to demonstrate the difference. copy it to source dir
from here
https://docs.google.com/file/d/0B6o29pwkWoERd3VuUm1DN0FpcUU/edit?usp=3Dsharing

build and
run "time ./mdb_copy foo foo2"
after this change the flag at line 64 and run it again.
at my computer the difference is 17s vs 1.7s for 3 million items.



On Tue, Aug 20, 2013 at 9:04 PM, Quanah Gibson-Mount <quanah(a)zimbra.com>wro=
te:

> --On Sunday, August 18, 2013 11:46 AM +0000 romange(a)gmail.com wrote:
>
>  Full_Name: Roman Gershman
>> Version:
>> OS: linux 3.8.0-25-generic
>> URL:
>> Submission from: (NULL) (212.150.97.210)
>>
>
> Please provide further information, specifically:
>
> The size of values
> Insert order
> Sample code if possible
>
> Thanks,
> Quanah
>
>
> --
>
> Quanah Gibson-Mount
> Lead Engineer
> Zimbra, Inc
> --------------------
> Zimbra ::  the leader in open source messaging and collaboration
>



--=20
Best regards,
     Roman

--001a11c1e98008372804e46726c2
Content-Type: text/html; charset=3DUTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D3D"ltr"><div>Hi, I extracted a small dataset that shows the proble=
=3D
m.</div><div>you can download it from here: <a href=3D3D"https://docs.google.=
=3D
com/file/d/0B6o29pwkWoERdnFSaUtMNDljemc/edit?usp=3D3Dsharing">https://docs.go=
=3D
ogle.com/file/d/0B6o29pwkWoERdnFSaUtMNDljemc/edit?usp=3D3Dsharing</a></div>

<div><br></div><div>I modified mdb_copy.c to demonstrate the difference. co=3D
py it to source dir from here <a href=3D3D"https://docs.google.com/file/d/0B6=
=3D
o29pwkWoERd3VuUm1DN0FpcUU/edit?usp=3D3Dsharing">https://docs.google.com/file/=
=3D
d/0B6o29pwkWoERd3VuUm1DN0FpcUU/edit?usp=3D3Dsharing</a></div>

<div><br></div><div>build and=3DC2=3DA0</div><div>run &quot;time ./mdb_copy f=
oo=3D
 foo2&quot;</div><div>after this change the flag at line 64 and run it agai=3D
n.</div><div>at my computer the difference is 17s vs 1.7s for 3 million ite=3D
ms.</div>

<div><br></div></div><div class=3D3D"gmail_extra"><br><br><div class=3D3D"gma=
il=3D
_quote">On Tue, Aug 20, 2013 at 9:04 PM, Quanah Gibson-Mount <span dir=3D3D"l=
=3D
tr">&lt;<a href=3D3D"mailto:quanah(a)zimbra.com" target=3D3D"_blank">quanah(a=
)zimbr=3D
a.com</a>&gt;</span> wrote:<br>

<blockquote class=3D3D"gmail_quote" style=3D3D"margin:0 0 0 .8ex;border-left:=
1p=3D
x #ccc solid;padding-left:1ex">--On Sunday, August 18, <a href=3D3D"tel:2013"=
=3D
 value=3D3D"+9722013" target=3D3D"_blank">2013</a> 11:46 AM +0000 <a href=3D3=
D"ma=3D
ilto:romange(a)gmail.com" target=3D3D"_blank">romange(a)gmail.com</a> wrote:<=
br>


<br>
<blockquote class=3D3D"gmail_quote" style=3D3D"margin:0 0 0 .8ex;border-left:=
1p=3D
x #ccc solid;padding-left:1ex">
Full_Name: Roman Gershman<br>
Version:<br>
OS: linux 3.8.0-25-generic<br>
URL:<br>
Submission from: (NULL) (212.150.97.210)<br>
</blockquote>
<br>
Please provide further information, specifically:<br>
<br>
The size of values<br>
Insert order<br>
Sample code if possible<br>
<br>
Thanks,<br>
Quanah<br>
<br>
<br>
--<br>
<br>
Quanah Gibson-Mount<br>
Lead Engineer<br>
Zimbra, Inc<br>
--------------------<br>
Zimbra :: =3DC2=3DA0the leader in open source messaging and collaboration<br>
</blockquote></div><br><br clear=3D3D"all"><div><br></div>-- <br>Best regards=
=3D
,<br>=3DC2=3DA0 =3DC2=3DA0=3DC2=3DA0 Roman
</div>

--001a11c1e98008372804e46726c2--



--===============2474895974570553513==--