[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: (ITS#7667) performance degradation when using MDB_INTEGERKEY



--001a11c1e98008372804e46726c2
Content-Type: text/plain; charset=UTF-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=sharing

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

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@zimbra.com>wrote:

> --On Sunday, August 18, 2013 11:46 AM +0000 romange@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
>



-- 
Best regards,
     Roman

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

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

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

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

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

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


<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
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 :: =C2=A0the leader in open source messaging and collaboration<br>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br>Best regards=
,<br>=C2=A0 =C2=A0=C2=A0 Roman
</div>

--001a11c1e98008372804e46726c2--