[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 "time ./mdb_copy foo=
foo2"</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"><<a href=3D"mailto:quanah@zimbra.com"; target=3D"_blank">quanah@zimbr=
a.com</a>></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--